Hinding sheet objects

[#1]

Hey, i was trying to have buttons in my sheet which wud toggle between different sheet objects. But i can't find an option to hide sheet objects. Can someone help me out with this?

[#2]

Hi

use conditional show in Layout tab in object preferences.

Regards

Przemek

[#3]

could u pls elaborate?

thanks in advance

Pulkit

[#4]

Could you please elaborate on that?

thanks in advance

Pulkit

Pulkit Sachdeva | Intern | +91 9008419263 | www.mu-sigma.com<http://www.mu-sigma.com/> |

[CELAMBARASAN]

Hi,

     Go to chart properties-->Layout tab-->under show use condition option.

     On click button set a variable with some value then use that value in condition like

     =if(variable=value,1,0)

     1 is to show(true)

     0 is to hide(false)

Hope it helps

Celambarasan

[#6]

Look at attached example.

Regards

Przemek

[jagan]

Hi,

Please check the attachment for solution.

Regards,

Jagan.