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.
purplerayn wrote:
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?
--
purplerayn
------------------------------------------------------------------------
purplerayn's Profile: http://www.excelforum.com/member.php...o&userid=28248
View this thread: http://www.excelforum.com/showthread...hreadid=478044
--
Dave Peterson