Hiding and showing tabs.

[#1]

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?

[#2]

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

[Peter_Cammaert]

Use either:

• Buttons to navigate to specific areas of your document. Each button has to have actions that hide/show related sheets
• Sheet triggers (OnActivate) that hide/show related sheets directly, without any additional manipulation.

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