Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Home tab, Tab 1, Tab 2, Tab 2a, Tab 2b, Tab 3, Tab 4, Tab5, Tab 5a, Tab 5b
I want only Home tab,Tab 1, Tab2, Tab 3, Tab 4 and Tab 5 to appear on the home screen.
When i click on Tab 2, i want only home tab, tab 2a and tab 2b to be seen.
Similarly when I click on Tab 5, i want to see only home tab,tab 5a and tab 5b.
I want to use the home tab to go to the home screen.
How to do this?
Hi
You can use Sheet Triggers.
Settings ->Document Properties --> Click On sheet --> On Activate -->Add Actions --> Layout --> Activate Sheet in that give the sheet ID.
On Open you activate only Home tab and tabs 1 to 5.
On Activate of Tab1 have only Home Tab1 and Tab1a to Tab1b
click on Home tab now on activate of Home tab you activate only Home and Tab1 to Tab5
Use either:
Triggers/Actions are your solution. If you decide to use buttons, you can disable the tabrow entirely, thereby recovering some precious screen real-estate.
Peter