protection - hiding worksheets

C

confused

hi,

I want to be able to open a workbook and be able to see all the worksheets
within it, but I want all other users to open the worksook and see only 3 of
the worksheets.
Is there some way of protecting the workbook to make this happen?

thanks for your help!
 
M

Mallycat

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

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


Matt
 
A

Arvi Laanemets

Hi


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

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

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


Arvi Laanemets
 
C

confused

but if I do this, it means when I open the workbook, I will not be able to
see the sheets either?
 
A

aidan.heritage

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.
 
I

Ian Digby

Are yourself and the other users on a Windows network? If so, you can
probably easily achieve your goal. Let me know if you are on a network and I
will send you the required code, which should work (but I don't guarantee it!)

Regards
Ian
 
Top