Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
password protect individual sheets
I see that I can password protect an entire workbook but is there a
way to protect individual sheets? That is, when a user tries to tab onto one excel will prompt for a password before allowing it to open. The reason for this is I have several sheets that different users will update but they do not want others to see their data but there is also a combination sheet that combines portions of their data so it would be a real pain to do this in separate workbooks. I know I could do something with the SelectionChange or with hiding sheets or by making text white but I want something relatively bullet proof that a savvy user would not be able to easily circumvent by simply unhiding a sheet or changing colors. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
password protect individual sheets
It happens that zxcv formulated :
I see that I can password protect an entire workbook but is there a way to protect individual sheets? That is, when a user tries to tab onto one excel will prompt for a password before allowing it to open. The reason for this is I have several sheets that different users will update but they do not want others to see their data but there is also a combination sheet that combines portions of their data so it would be a real pain to do this in separate workbooks. I know I could do something with the SelectionChange or with hiding sheets or by making text white but I want something relatively bullet proof that a savvy user would not be able to easily circumvent by simply unhiding a sheet or changing colors. Sheet protection will only prevent users from editing locked cells unless they know the password. Sounds to me that you need some methodology to manage the display of individual sheets that maybe requires a userform type of login to display the appropriate sheets for that user. Usernames, passwords, and a list of sheets each user is allowed to view/access can be stored in a hidden worksheet. In your case, the setting for hidden sheets should be 'xlVeryHidden' so they don't appear in the hide/unhide dialog. Also, you'll need to password protect the VBA project to keep users from messing with it that way. The login form might include a ListBox where users can select the sheetnames of sheets they want to access/view. Provide a button or menuitem whereby users can bring up the userform, OR have it load via the Workbook_Open event. HTH -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password protect individual tabs in an excel spreadsheet | Excel Discussion (Misc queries) | |||
Password protect select sheets in a workbook | Excel Programming | |||
password protect sheets | Excel Worksheet Functions | |||
password protect individual worksheets | Excel Discussion (Misc queries) | |||
Protect Excel sheets with Password Using VBA | Excel Programming |