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!

bump

"_ian2006_" wrote:

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!

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.



_ian2006_ wrote:

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!

--

Dave Peterson

No.

If the partners have enough savvy to find these newsgroups, they'll be
able to bypass any method you use. See:

http://www.mcgimpsey.com/excel/removepwords.html

In article ,
_ian2006_ wrote:

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!