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

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