Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shared Workbook Protection
Hi
I have a workbook with 12 sheets. Ten of these contain data from different business areas which feed into the two summary sheets at the front. Each business manager provides confidential information that I don't want the other managers to be able to view. Is it possible to password protect each of the ten sheets individually so that they can only be viewed by the owner - ie prompt for a password to open when the tab is clicked on? The workbook will live on a Sharepoint. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Shared Workbook Protection
No.
Any solution that I'd try would depend on macros and macros can be disabled. If you have confidential information that shouldn't be shared, then don't put it in excel. Or don't share the file with people who shouldn't see it. BT wrote: Hi I have a workbook with 12 sheets. Ten of these contain data from different business areas which feed into the two summary sheets at the front. Each business manager provides confidential information that I don't want the other managers to be able to view. Is it possible to password protect each of the ten sheets individually so that they can only be viewed by the owner - ie prompt for a password to open when the tab is clicked on? The workbook will live on a Sharepoint. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change protection of a shared workbook (Excel 2000) | Excel Discussion (Misc queries) | |||
protection from shared workbook | Excel Discussion (Misc queries) | |||
Shared Workbook Protection | Excel Discussion (Misc queries) | |||
Removing shared workbook protection | Excel Discussion (Misc queries) | |||
Shared workbook protection | Excel Discussion (Misc queries) |