Hiding Sheets
 

I would like to hide a sheet so that it is only visible to certain users. I
do not think the Format, Sheet, Hide command is not secure enough. I would
like to use the Very Hidden Option -- which I know how to do. I DO NOT,
however, know how to only restrict the sheet to certain users using either
the Format Sheet command or the Very Hidden Option. Any suggestions? Thank
you.

Kim

I don't think this is possible from either VBA or the GUI.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Kim" wrote in message
...
I would like to hide a sheet so that it is only visible to certain users.
I
do not think the Format, Sheet, Hide command is not secure enough. I
would
like to use the Very Hidden Option -- which I know how to do. I DO NOT,
however, know how to only restrict the sheet to certain users using either
the Format Sheet command or the Very Hidden Option. Any suggestions?
Thank
you.

Thank you very much for your response.

"Nick Hodge" wrote:

Kim

I don't think this is possible from either VBA or the GUI.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Kim" wrote in message
...
I would like to hide a sheet so that it is only visible to certain users.
I
do not think the Format, Sheet, Hide command is not secure enough. I
would
like to use the Very Hidden Option -- which I know how to do. I DO NOT,
however, know how to only restrict the sheet to certain users using either
the Format Sheet command or the Very Hidden Option. Any suggestions?
Thank
you.

You would need to control this absolutely yourself, maybe adding some code
in the workbook open that checks the user and unhides it for nominated
users. Big maintenance though, keeping the list up to date.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Kim" wrote in message
...
I would like to hide a sheet so that it is only visible to certain users.
I
do not think the Format, Sheet, Hide command is not secure enough. I
would
like to use the Very Hidden Option -- which I know how to do. I DO NOT,
however, know how to only restrict the sheet to certain users using either
the Format Sheet command or the Very Hidden Option. Any suggestions?
Thank
you.