Password Protecting Sheets in Excel So Others Can't See Certain Sh

I

_ian2006_

Hopefully this won't be too confusing. I have a workbook with 3 sheets in it.
One sheet for one partner, one for another, etc.
Without having to create 3 separate workbooks, is it possible to create a
password for each sheet so that only that partner can view that particular
sheet. In other words, I don't want one partner to be able to view the other
two partners' sheets.

thanks!
 
D

Dave Peterson

Protecting worksheets in this manner won't stop anyone who is interested from
seeing the other sheets.

If you have stuff others shouldn't see, don't share that workbook with them.
 
Top