Always hidden tabs ?

[massam]

Hi,

- I have 3 sheets, mainsheet, data1 and data2.
- I have hyperlinks from mainsheet to both data1 and 2.
- I have vb code that hides data1 and 2 when Im on mainsheet.
Is it possible to always hide the tabs ? Basicly what Im trying to achieve is that when I click on the hyperlink on mainsheet to data1, that data1 is opened but the data1 tab is not visible.

Thanks

 

[Chihiro]

Welcome to the forum.

You mean have the sheet (data1) visible, but not the tab menu at the bottom of the screen?

You can hide entire tab menu, but not individual tabs.

To hide entire tab menu...
Options->Advanced
Scroll down to "Display options for this workbook"
Uncheck "Show sheet tabs".


Alternately you can use VBA code to control it.

'Hide
ActiveWindow.DisplayWorkbookTabs = False
'Show
ActiveWindow.DisplayWorkbookTabs = True

 

[Luke M]

Where would the hyperlink be taking you then, if the sheet is hidden? Wouldn't you just stay on the main sheet?

EDIT: Looks like Chihiro understood better.

 

[Peter Bartholomew]

@Luke M
You can achieve some interesting user interface behaviour by using VBA to switch sheets without the tabs showing. For example if there are two different cases of a calculation (a set of stats tests presented one such instance) clicking an option control actually changes sheet but all the user sees is an output block that has changed; there is no indication that the active sheet has changed.

A key aspect of creating the illusion is that user input settings including panning and zoom state need to be copied across to the new sheet.

 

[Peter Bartholomew]

If you want to see an example of sheet navigation with sheet tabs hidden, one can be found at:

http://www.statspeople.com/best-worst-case-2/
Follow the link to: Significance Testing & Confidence Interval Toolkit