Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to know is what this possible to create button to activate multiple sheets at once, a sheet with several buttons each button to activate a document with multiple sheets.
Best regards
Maurice
Hi Maurice,
it is possible to do....
initially create a variable like vshowhide
and
Create a...button object with some action.
go to button properties
in actions tab
add action
set variable in External
in that add variable as variable name and assign the value like this...
=if(vshowhide=1,0,1)
and
go to the sheets and
in sheet properties make conditional with variable.
in conditional add value like this...vshowhide=1
and
make this conditional to multiple sheets.
then you are going to achieve your requirement.
after this when your clicking on the button object it is going to hide multiple sheets by the single click
and when ever you are click on that particular button object again it is going to show multiple sheets.
Thanq.
After creating variable,
add action in button like this.........as fallows.
then,
go to the sheet properties
make conditional like this....as fallows....
you can do like this conditional on multiple sheets if you want.
Thanq.
Hello,
I would like to make disappear all the sheet when I return on the sheet Accueil
here is an example thank you
Hi Maurice,
You would putting the same logic on all sheets conditional show as Kalyani explained, and one additional thing to be done is, as per your requirement,
On "Accueil" sheet properties, goto Triggers tab, then click on Edit action under OnActivatesheet trigger and include the set variable option and use vshow in Variable textbox and value as 0.
Hi Ganesh,
it does not work can you please look her thank you
I cannot open your app as I'm using a Personal Edition,
PFA,
Check and lemme kno.