Drawing Toolbar AutoShapes greyed out 3

[NorthNone]

I have eliminated these as possible explanations for the AutoShapes being greyed out in an Excel workbook:
1. Is not Protected
2. Worksheets are not grouped
WHY ELSE (sorry for shouting...) would AutoShapes be greyed out?
Help, please. My hair is starting to look greyed out LOL!

---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.

 

[AndyPope]

Hi,

It's not a shared workbook is it.

Cheers
Andy

 

[NorthNone]

Thanks for responding, Andy, but no it is not a shared workbook.

---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.

 

[Zathras]

It might help if you said what version of Excel you are using.

What happens on a new sheet in the existing workbook?

What happens on a totally new workbook?

 

[NorthNone]

Good questions, Zathras & thanks for posting
Excel 2002
New sheet in the existing workbook has the same problem.
A totally new workbook is fine. The Drawing tool bar is enabled.


---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.

 

[Zathras]

Do you have "track changes" set? (That will automatically share the workbook and disable the shapes.)

 

[NorthNone]

Sorry, no. Track Changes is not set.

---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.

 

[AndyPope]

Try Tools > Options > View.
Objects should be NOT be "Hide All"

 

[NorthNone]

THANK YOU!!!! That was it! A star for you Andy!

---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.

 

[NorthNone]

And a star for Zathras for great diagnostic questions!

---------------------------------------
The customer may not always be right, but the customer is ALWAYS the customer.