Hiding Sheets as Very Hidden using VBA

[MartinS]

Hi All
Is it possible to set sheets to be very hidden (as is possible within the VBA environment) using VBA code?
Setting the sheets to visible is OK, but users can easily unhide them - I'd like to be able to ensure the user can only see the sheet I want.
Cheers
Martin

 

[markdooler]

[FONT=&quot]So here is the code from a macro i created to select a sheet and hide the other sheet (used for navigating from a dashboard to individual sheets, there is a corresponding macro to go back).[/FONT]
[FONT=&quot]Sub gotohoursturnover()
' gotohoursturnover Macro
Sheets("Home").Select
Sheets("Dashboard (Hours & Turnover)").Visible = True
Sheets("Home").Select
ActiveWindow.SelectedSheets.Visible = False[/FONT]
[FONT=&quot]My question is how do i make this statement "ActiveWindow.SelectedSheets.Visible = False" make the sheet very hidden?[/FONT]
[FONT=&quot]I have tried replacing the "false" with "xlSheetVeryHidden" but it just throws up an error.[/FONT]
[FONT=&quot]Yes it may be simple but i am just working out vba lol.[/FONT]
[FONT=&quot]Thanks[/FONT]
[FONT=&quot]Mark[/FONT]