Protecting Sheets within a workbook

S

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
 
P

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 **
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Password protecting sheets in a workbook 4
Protecting Worksheets 1
Save all sheets in a new workbook 7
Linking cells on different sheets within a workbook. 1
Individual sheet protection in shared workbook 1
move worksheet to end of another workbook 3
macro to sum select columns in all workseets within a workbook 2
Accessing Other Sheet Tabs from within Excel 2

Top