Hide Sheet Q

G

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
 
S

Sean

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

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

[email protected]
[email protected] with @tiscali.co.uk
 
S

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
 
Top