Hi

I have a workbook and would like to achieve the same as item below
Also to have some users sheets unhidden but protected.

- "I have apps where another sheet, "control" always remains
very hidden. This sheet defines which of the hidden
sheets will be made visible to whichever user opens the
file....using the NT logon as the identity. If somebody
not on the list opens the file, then only the splash
sheet is visible. Patrick Molloy,Microsoft Excel MVP"-

Have found how to get the users logon name, but cannot see how to us
this to compare to the users permissions on a 'control' sheet.

Thanks for any advice.

Maxwel

--
Message posted from http://www.ExcelForum.com