Shared Workbook Protection

[BT]

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]

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.