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. |
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 |