Protecting Sheets within a workbook

[senman]

I have an excel workbook that has twenty sheets to it. I
want to be able to have individual people access different
sheets for filling in data (assign a password to each
sheet?). I do not want that person to be able to see
other peoples info in other sheets. Can this be done?

If you click on a sheet tabe it will ask you for a
password?

Trying to set something up that is idiot proof.

thanks for your suggestions.

sue

 

[Paul B]

Sue, have a look,
http://makeashorterlink.com/?U248122F8

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **