software

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

quot;_ian2006_quot; wrote:

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

www.mcgimpsey.com/excel/removepwords.html

In article gt;,
_ian2006_ gt; wrote:

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