View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default Password Protecting Sheets in Excel So Others Can't See Certain Sh

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