protection - hiding worksheets

[Guest]

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!

 

[Mallycat]

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

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


Matt

 

[Arvi Laanemets]

Hi

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

 

[Guest]

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

 

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

 

[Guest]

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