only few users can access the worksheet... is that possible?

  • Thread starter Thread starter htnoam
  • Start date Start date
H

htnoam

hiii.
i created a workbook that contains 6 worksheets.
Two of those worksheets needs to be viewd only by a few users (whom i
will choose), is it possible to prevent all users but 5 to access to a
specified worksheet?

thanks,
noam.
 
Hi
one idea:
- you can hide these worksheets and protect the workbook ('Tools -
Protection')
- only give those user the workbook password to unhide these sheets

Note: Excel's protection mechanism are very weak for determined users
:-)
 
i created a workbook that contains 6 worksheets.
Two of those worksheets needs to be viewd only by a few users (whom i
will choose), is it possible to prevent all users but 5 to access to a
specified worksheet?
Click to expand...

Without VBA, only by hiding those worksheets, password protecting the workbook,
and giving only the users authorized to see the hidden worksheets the workbook
protection password. With VBA, if your users would be logged onto a LAN when
they open your workbook, you could use the fOSUserName function - see

http://www.google.com/groups?selm=eh0CkEwo$GA.1756@cppssbbsa06

to determine the current user's network ID, then compare it to a list of users
who should have access to the hidden worksheets and unhide them automatically.
This would all be done in the Workbook_Open event handler.
 
Back
Top