Protect a worksheet

[ddmtn546]

What would be the best way to restrict access to some worksheets but not others? However, in general, most users will only need to view one worksheet, while others may need other worksheets. all contained in the same workbook. Thanks in advance.

 

[cc30729]

If the different users just require viewing and data manipulation access, you could create a separate workbook that links to just the specific sheet you to which you want the user to have access. Accordingly, if you wanted a different sheet available for a different user, just create another workbook linked to the respective information.

This is what I have done so that all the relevant data for user Joe in workbook AA can be seen by Joe using workbook BB and user Wendy can see the data in workbook relevant to her by viewing workbook CC. Hope that makes sense and helps.

 

[KenWright]

Another option would be to hide all sheets except a single introductory one (Use xlveryHidden via VBA), and then have each user choose a password, and depending on their password, unhide the relevant sheet for them. You could then use a Before_Save event to hide all sheets again so that the user doesn't have to do it. You would need to ensure that you protected the VBA project so that they couldn't get in and see the code, else they would get the other passwords.

Regards
Ken....................

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------