How to enable items on Excel draw menu bar.

J

JD

On an excel spreadsheet the buttons on the draw menu bar became disabled and
I need to enable them. I have checked permissions and can't find what is
causing this.
 
G

Gord Dibben

Sounds like the sheet is protected under Tools>Protection.


Gord Dibben MS Excel MVP
 
J

JD

Thanks for the info. I found out by trial and error that I had to go to
Tools/Options/View tab then select the Objects/Show all radio button. After
doing this, I was then able to insert and use text boxes and the other items
 
Top