Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 4 sheets consequently as Sheet1,Sheet2,Sheet3,sheet4.
How to show them one sheet each time?
HI,
it is simple way to do this in three steps
1) First create four buttons for each sheet in in each button with action activate sheet.
2) In Document properties -> General -> clicking on Hide tabrow.
3) after hide tabrow it will show only one main sheet which you created buttons for sheets and by clicking on each button it will display your sheets.
Check this.
Regards
ASHFAQ
Hi,
Please use the button and variable to achieve this.
steps:
1.Create a variable with value 0.
2.Create a button , then use the button action properties to set the variable for 0 or 1.
3.Go to sheet properties and use the conditional show option to hide and show