Hide Sheet Q

[Sean]

How do I remove the ability of a User to Unhide a hidden Sheet?

Thanks

 

[Gord Dibben]

You could through VB Editor make the sheet xlveryhidden then put password
protection on the VBA project. This password is quite a bit harder to crack
than internal passwords.

Sub test()
Worksheets("Sheet1").Visible = xlVeryHidden
' Worksheets("Sheet1").Visible = True
End Sub


Gord Dibben MS Excel MVP

 

[Sean]

worked it I need Sheets.Visible = xlVeryHidden to be semi-truly hidden
(at least from format - unhide)

 

[Sandy Mann]

If ypou can hide it then someone else will be able to unhide it if they have
enough knowledge. The Macro:

Sub HideIt()
Sheets("Q").Visible = xlVeryHidden
End Sub

will hide Sheet Q so that it does not show in the list of hidden sheets.

to unhide it replace xlVeryHidden with TRUE then run the macro


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Sean]

Thanks all

Is xlVeryhidden supported in Excel 2000? I use a mixture of XP and 2000
so I'd want it to work over both platforms