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
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.
Thank u, but my requirement is initially current selection box should be hide, when made selections it would be active show.
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.
Hi sudhir its perfectly working. Thanx on ur work.
Retrieving data ...