Shared Workbook Protection

B

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

password protection 7
Protecting workbook sheets 3
Password protection 5
Excel Data Protection Best Practice: AKA: Real Sheet Protection 4
Macro for protecting and unprotecting multiple worksheets 7
Excel Shared Workbook 1
Multiple Worksheets 6
Losing Cell Protection When Saving Workbook 5

Top