Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
Settings > Sheet Properties > (select the object) > Properties
Regards,
Gordon
Settings > Sheet Properties > (select the object) > Properties
Regards,
Gordon
Hi,
go to SETTINGS > DOCUMENT PROPERTIES > SECURITY
and check the option SHOW ALL SHEETS AND OBJECTS
Done!!!
Rainer
Ctrl+Shift+S is a really useful shortcut to Show All Sheets & Objects
Very Good!!!!!!!!!!!!!!!!!!!!!!!!!!!!
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 : )
Thanks! I was starting to think I was going blind, not finding this menu...
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.