Cannot get chart or illustrations ribbon enabled


R

RandyWillaman

I have a complex spreadsheet that has disabled the illustrations and chart
toolbars. I have checked all the properties, permissions, etc., and these
toolbars will not work.

If I open up a new spreadsheet then these toolbars work fine. Something has
turned them off. I deleted all the worksheets in the 'broken' workbook and
the toolbars still do not work.

How can I figure out why these toolbars will not enable?
 
Ad

Advertisements

R

RandyWillaman

Found the problem. In the "Display Options for this Workbook" the "For
Objects, show" was set to "Hide Objects". Changed it to "All" and it now
works. I have no idea how it changed...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top