Change worksheets on view when password entered to open workbook

Hi All,

I'm hoping to once again tap into the vast excel forum brain for help.

I have a workbook with 20 worksheets. What I would like to do is password protect the workbook as normal, but, have multiple passwords to open. When opened certain worksheets will be hidden dependant on the password used.

e.g.

Password entered is: SALES
Worksheets visable = 1-10

password entered is: ADMIN
Worksheets visable = 1-20

I have been scouring the web for an answer and have got close but not close enough.

Hoping you can help

Regards

SBG

Thanks for the response. I am not familiar with a User form, could you detail how to put this together so I can see if its workable?

Many thanks

SBG1