Excel 2000 WorkSheet Tabs - turning off

[ronboyes]

Is it possible to hide the tabs for specfic sheets in a workbook.
The selection in tools/options/view sheet tabs turns off tabs in all sheets in the workbook.
Is there a way to hide tabs only in selected worksheets.

thanks and regards
ron

 

[Zathras]

If you really want to do what you described, you can: With VBA you can do something like this:

Private Sub Worksheet_Activate()
 ActiveWindow.DisplayWorkbookTabs = False
End Sub

Put that in the code page for each sheet for which you want to hide tabs. Of course, as soon as you select one of those sheets, the tabs are gone and you cannot select any other sheet, without putting your own device on the page. Either a command button or a hot key can be used to invoke a macro to select a different sheet and re-display the tabs.

Perhaps what you really want is to hide individual sheets so they can't be selected?

 

[ronboyes]

Hi Zathras,

Thanks for the response.
I shall explain how I am using the worksheet and you may be able to offer a better way achieve the result I am after.

The first sheet in the workbook is used as a splash screen (no need for tabs) this scrren has a link to another sheet I have named "index" (tabs to be displayed on this and all other sheets). I have 14 sheeets to this workbook.

While I can live with the tabs being displayed on the splash screen - it just looks better without them.

In addition it needs to be work on older versions of Excel as I am sending this to my customers.

appreciate your help

Regards
ron

 

[TonyJollans]

Hi ronboyes,

Afraid I don't know about pre-97 but if you just want it on the one sheet then do what Zathras says in the Sheet Activate event and reset it (= True) in the Sheet Deactivate event. No need to do anything to any other sheets.

Removing tabs, of course, does not stop Users using the keyboard to move between sheets.

Enjoy,
Tony

 

[sc11pio]

Hi,

If you are talking about hiding the tabs, why don't you hide the worksheets?

To hide certain worksheet, you can just click on the worksheet, and click Format > Sheet > Hide.

Not sure if this is what you want =)

Reg,
Pio