Protecting Sheet to Prevent Viewing At All

The following code will make the sheet 'invisible' to ordinary users:

Sub hideit()
Sheets("Sheet2").Visible = xlVeryHidden
End Sub

To unhide it use

Sub unhideit()
Sheets("Sheet2").Visible = True
End Sub


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200507/1

Both this and the other reply, below, will be phenomenally useful. Thank you
both! The Excel rescue team comes through again!

"VoG" wrote:

> The following code will make the sheet 'invisible' to ordinary users:
>
> Sub hideit()
> Sheets("Sheet2").Visible = xlVeryHidden
> End Sub
>
> To unhide it use
>
> Sub unhideit()
> Sheets("Sheet2").Visible = True
> End Sub
>
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...excel/200507/1
>