How to swich the "show" property from always to conditional in text object?

[yanivvl0]

hi to all ,

i am trying  ( by macro ) to swich the "show" property from always to conditional in a text object , and give to the conditional  an expresion ,

i need to do it for a specific text object in specific sheet ,

can anybody know how to do this ?

thank u for your time.

[jagan · Accepted solution]

Hi,

Why you are using macro instead you can just use variables or expression to show and hide the text object.  There are lot of issues with macros.

Regards,

Jagan.

[#3]

Hi

Go through below link,

How to hide and show the tables based on two buttons.

[yanivvl0]

THANKS

[yanivvl0]

THANKS

MUCH HELP.

[jagan]

Hi,

Please close this thread if you got the solution.

Regards,

Jagan.

[yanivvl0]

HI JAGAN ,

HOW DO I close this thread ?

[yanivvl0]

HI HARSHAL ,

NICE CODE , THANK U !!

[jagan]

Hi,

Just click on Correct Answer and Helpful Answer to the helpful posts.

Regards,

Jagan.