Protecting Sheet

P

purplerayn

I am setting up a workbook with several sheets. Each sheet is to be
updated each day by a respective salesperson. I want to be able to
send the entire workbook to each person but disallow them from opening
another salesperson "sheet". Can I password protect each "sheet" so
that each person can only open "their" sheet?
 
D

Dave Peterson

Not really.

Excel's protection is to stop people from overwriting formulas--not to protect
information from others.

If there's something that you don't want others to see, don't put it in
excel--or don't share that workbook with others.
 
Top