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!

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

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


Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=553532

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

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

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

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
--
Work performed in the spirit of service is worship...Baha''i Writings


"confused" wrote:

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!