Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
I want to determine on a sheet which objects are visible or minimized. Does anybody know of a function or property of
GetSheetObject that will allow me to do this?
The IsMinimized method can be used to determine if the object is minimized. I haven't found a way to check an objects showmode yet to determine if the object is visible or hidden.
Dear ,
for hidden objects wee can see like these,
Settings--->Document Properties-----> Security--->User Privileges-->
check -->
Show All sheets and objects
Thanks,
Mukram.
You can see all hidden objects by going into Sheet Properties (Settings -> Sheet Properties) then the Objects tab to see the ShowMode. Note: this will only show you the objects on a given sheet, not across all sheets.