Hiding Sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
(e-mail address removed)
 
Thank you very much for your response.

Nick Hodge said:
Kim

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
Click to expand...
 
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)
 
Back
Top