Hide sheet tabs

[sms2luv]

I want to hide the sheet tab, there is an excel option to do that, but any user can check the view sheet option and view all sheets.
I am aware about using very hidden in VBA, that will hide the required sheet.
Is there any way, we can lock the sheet tab option for a workbook.

 

[Logit]

In the Sheet level module you could use this :

Option Explicit
Private Sub Worksheet_Activate()
    Sheet2.Visible = xlSheetHidden
End Sub

The only way to open the sheet then would be via the VB Editor ?

 

[sms2luv]

Let me repeat my query again.
I am not referring to Sheets, I want all sheet tabs to be hidden.

 

[NARAYANK991]

Hi ,

Hiding the sheet tabs is simple , but a user can easily access the Excel Options and turn them on again.

Disabling the Excel Options is more difficult and involves modifying the XML file.

For just turning off the sheet tabs , try this :

ActiveWindow.DisplayWorkbookTabs = False

Narayan

 

[Logit]

EXCEL button, upper left corner.
Options
Advanced
Display options for this workbook
Show sheet tabs

 

[sms2luv]

EXCEL button, upper left corner.
Options
Advanced
Display options for this workbook
Show sheet tabs

I am aware about the option in Excel option.
But as mentioned earlier, anyone can go to options and enable the sheet tab.
What I want is that it should be hidden via VBA so that it cannot be enabled without password.

 

[Logit]

ActiveWindow.DisplayWorkbookTabs = False