Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to check object visibility

Hi,

Is it possible to check whether an object on active sheet is visible or hidden?

Thanks

6 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Right click on the sheet -> Properties -> Objects 

     Here you will find all the objects and their respective property, Here "ShowMode" will tell you whether its visible or hidden.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
sivarajs
Specialist II
Specialist II

One way to check is like below

bullish35
Creator II
Creator II

Using CTRL-SHIFT-S you can toggle between showing all objects and hiding those in hidden mode. It's one of my favorite commands!

Not applicable
Author

Hi All,

Thanks for the reply,

I'm familiar to the option you people have explained. But I want to check it in one of the graph and set its value accordingly. Its value changes based on visibility of some other object next to it.

Not applicable
Author

Hi,

try to insert in a text object the expression of Layout -> Conditional Show of the object.

if the expression = 1 then the object is visible, else no.

Hope this helps

Clever_Anjos
Employee
Employee

You say, using an expression or visually?