Show hidden objects

[#1]

Hi,

In developer mode, I've accidently set a condition on show hide object which is incorrect.

I can't get the object to show since I can't remember the erroneous condition.

How can I make all objects on a sheet appear (disregard the conditional show).

[#2 · Accepted solution]

Settings > Sheet Properties > (select the object) > Properties

Regards,

Gordon

[#3]

Hi,

go to SETTINGS > DOCUMENT PROPERTIES > SECURITY

and check the option SHOW ALL SHEETS AND OBJECTS

Done!!!

Rainer

[#4]

Thanks

Though

gordon.savage

answer also worked, just the other guys was faster for what i wanted

[RickWild64]

Ctrl+Shift+S is a really useful shortcut to Show All Sheets & Objects

[michaelfreitas]

Very Good!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[#7]

Just to complete the answer

if your document has data reduction, the option 'Document Objects' will appear only if you are a ADMIN if you are a USER at the Section Access this option won't be avaliable for you : )

[erikkorme]

Thanks! I was starting to think I was going blind, not finding this menu...

[#9]

Thanks Daniel for asking this question. Same problem arised with me. Object viewer is pretty good.

As all answered, it fixed my problem as well. Now I am able to update the settings from settings>sheet properties> object tab and select the object and update the properties.

Nice and easy explanation. Thanks all.