The first thing to say is that if the information on the hidden page is
sensitive then don't do it. Excel security is like tissue paper and anyone
with a basic knowledge will unhide the sheet very quickly indeed. That said
if you want to proceed then use xlveryhidden as in this macro:-

Sub hideme()
msg = "Enter password"
response = InputBox(msg, vbCritical)
If response < "xxx" Then End '<Change as required

If Worksheets("revenue").Visible = True Then '<Change worksheet name as req'd
Worksheets("revenue").Visible = xlVeryHidden
Else
Worksheets("revenue").Visible = True
End If
End Sub

Mike

"The Rook" wrote:

I have an excel workbook that contain serveral worksheets. I am wanting to
set up security so that certain people can only veiw certain worksheets and
not others.

ie I have an Order book revenue sheet that I only want the MD & FD to view
but would like everyone ealse to view everything but this sheet.

Is it possible?

regards