It doesn't help that this message is in it's own thread without the
original question, but I'm GUESSING you want something like a sheet
being hidden unless you are the owner - I would set the sheets to
VERYHIDDEN (which means no one can get to them) and then assign a macro
EITHER to a keystroke to unhide them OR to run on open to (perhaps)
check for the current user and IF valid, unhide them.
confused wrote:
but if I do this, it means when I open the workbook, I will not be able to
see the sheets either?

"Arvi Laanemets" wrote:

Hi


"Mallycat" wrote in
message ...

You could use a simple macro to auto hide the sheets ie

Sub auto_open()
Sheets("Sheet1").Visible = False
End Sub

But anyone holding down Shift key when opening workbook, can bypass this.


Arvi Laanemets