hide and active sheet object while making selection?

[Anonymous]

Hi experts,

I want to enable my current selection box when any selection made in sheet, rest of time it should hide. What is the way to do that help on it .

Thanks & Regards

Pavan

[vishsaggi]

Create a variable vShow. Like

LET vShow = IF(Getcurrentselections() >0, 1,0);

Then in any sheet object properties -> Go to Layout Tab -> check conditional  and type =vShow

I hope this would work.

[Anonymous]

Hi vishwanath,

Thank u, but my requirement is initially current selection box should be hide, when made selections it would be active show.

[sudhir0538 · Accepted solution]

Hi Pavan

Replace the variable definition with this logic

"=if(count(GetCurrentSelections())>0,1,0)" and go to current selection box properties --> layout ---> show---> conditional

and write vShow=1.

I'm sure it'll work.

[Anonymous]

Hi sudhir its perfectly working. Thanx on ur work.