SHEETS HIDE AND SHOW

[#1]

I have 3 Sheets labeled Sheet1, Sheet2 and Sheet 3.   ON Each Sheet I have 3 buttons, each button is Called as

Sheet1, Sheet2 and Sheet 3. SO when I click on Sheet1, it shows only Sheet1 and hide the other sheets, or if I select Sheet2, it shows, Sheet 2 only and Hide the others. How can I do that

[varunreddy]

Right click on tabrow, you will find the image 1 option.

If you select button object, you will find the second screen shot

[prabhu0505]

Attached simple example.

[mayankraoka]

Rehan,

This link might help you:

How to show multiple sheets one sheet each time?

Regards,

Mayank

[#5]

NO its not a PErsonal Edition

[varunreddy]

I did it on personal edition.Can you tell me how you are doing?

[varunreddy]

Activating Sheets example

[#8]

This works great, but here is another problem, I have another sheet which is always there .  So when I toggle the buttons, it always activates the First Sheet even though i have the selected sheet as a second sheet, since 1st sheet is alkways there

[varunreddy]

Use trigger on open

Go to document properties - Triggers - OnOpen - AddActions - Setvariable - vbutton =1

[varunreddy]

When you open, it will always to go first sheet. If this is the answer, mention this as an answered.

This might help

Cheers!