How can you turn the tabs to switch sheets off and not let a

gdukric · Feb 7th 2003

I am doing a project and for security i would like to turn the worksheet tabs at the bottom off and keep them off. Is the a macro or VB coding that can sort this out?

**royUK** · Feb 7th 2003

Using VBA you can make your sheets hidden to all users

Sub HideSheet()
Sheet1.Visible = xlSheetVeryHidden
End Sub

If you hide your sheets this way, users will not be able to unhide them using the menus. Only using VB codes will be able to display the sheets again.

Code to open in another macro

Sheet1.Visible = True

To just hide the Tabs, users will still be able to access sheets by right clicking on the bottom right arrows.

Tools>Options and unselect Sheet Tabs

gdukric · Feb 14th 2003

Thanks :->

How can you turn the tabs to switch sheets off and not let a

Participate now!

Share

Users Viewing This Thread