protection - hiding worksheets
 

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!

protection - hiding worksheets
 

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

protection - hiding worksheets
 

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

protection - hiding worksheets
 

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

protection - hiding worksheets
 

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

protection - hiding worksheets
 

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!