How to prompt user to set password that protects their worksheet?

[Guest]

I have 50 worksheets tied to 50 different employees. Each on will be
updating their worksheet on a daily basis. I would like to be able to prompt
them to enter a password which will give them access to their individual
worksheet. I don't want to have to explain to each person how to protect the
sheet, instead if a message could appear as soon as they accessed the sheet
prompting them for a password. This also means that the first time that they
ever access it I want to ask them to create a password. Any help would be
appreciated.

 

[Tim Williams]

You could use a hidden name or sheet to hold the password. If it's not set
then ask them to provide one. It it is set them ask them what it is.
Are these 50 worksheets in the same workbook or different ones?

Tim

 

[Guest]

All 50 worksheets are in the same workbook. And there is about 50 worksheets
with the same 50 worksheets, but new data. It would be great if I could
create one worksheet (hidden) with all the names and passwords and tie it to
the 50 different workbooks/sheets. Is this possible?