Different Worksheet Passwords

Hi

I am relatively new to VBA and Programming code which is why i'm wondering if someone could point us in the right direction. Here is the issue

I have 12 worksheets each which have to be protected from other people from viewing unless you enter the password correctly for that worksheet. I then have a main page(Called Home) with 12 Macros on with people's names. When the person clicks on their name it then leads them to their worksheet (the password protected one).

Any ideas on how to go about it and the code needed to make this work? All the sheets and names are in place its just the coding that i'm not sure how to do.

Any help would be appreciated and bear in mind i'm new to this so please be gentle with me :D

Thanks

Andy.

I'd do the following:

(simple version)

1) Made all sheets (except of Home) very hidden
for instance:

Please Login or Register  to view this content.

2) then on your home sheet in one cell user shall select his name (easiest - data validation based on a list)
in another cell place for his password
a button calling "show_my_sheet" makro

or 2a) selection from list or combobox and password field (could set to beloved ****) and a button in a Userform (can be autoshown by Workbook_Open event)

3) code show_my_sheet macro setting visibility of "logged in" user sheet to xlSheetVisible

4) in the ThisWorkbook module in BeforeSave event again hiding all byt Home sheets - for instance using already coded sub:

Please Login or Register  to view this content.

5) of course protect the VBA project with password

Hope, I managed to be gentle

Hi

Thanks for your reply,

I have some code that i found somewhere else but can't get it to work. I would rather have a password for each worksheet than hiding them or creating forms. Here is what i have.

Please Login or Register  to view this content.

Cheers
Andy