How to enable items on Excel draw menu bar.

[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.

 

[Gord Dibben]

Sounds like the sheet is protected under Tools>Protection.


Gord Dibben MS Excel MVP

 

[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

 

[Gord Dibben]

Thanks for letting us know the solution.

I missed that one.


Gord