Hide Sheet Q

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sean - 15 Jan 2007 22:22 GMT

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

Thanks

Reply to this Message

Gord Dibben - 15 Jan 2007 22:40 GMT

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

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

Reply to this Message

Sean - 15 Jan 2007 22:41 GMT

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

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

Reply to this Message

Sandy Mann - 15 Jan 2007 22:42 GMT

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

Signature

HTH

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

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

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

Reply to this Message

Sean - 15 Jan 2007 23:01 GMT

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

> If ypou can hide it then someone else will be able to unhide it if they have
> enough knowledge. The Macro:
[quoted text clipped - 20 lines]
> >
> > Thanks

Reply to this Message

Rate this thread: