Display sheets depending on 'log in' credentials

[monkeychuff]

Hi Guys/Gals,

Firstly, I do not want to use Application UserName for this project and I do not want to create a user form for the log in.

I have a number of departmental sheets in a workbook, which contain sensitive information. I want to set the work book to open with all sheets hidden except the 'log in' sheet. In cell A1 of the 'log in' sheet the user has to select their name from a drop down and in cell A2 type their given password. When the user clicks the submit button, these details should then be used to reference the hidden 'admin' sheet, look up the user name in column A and ensure the password, contained alongside the user name, in column B matches. If there is a match the sheet(s) named, alongside the correct user details, in column C of the 'admin' sheet, should be displayed for editing. If there is no user/password match a message box should appear.

Doable?

Thanks in advance for your help.

 

[ww4612]

you can protect your workbook with password. First, manuall hide all the sheets except log sheet. then write macro for submit buttom. such as if cells(1,1).value = 123456 then sheets(2).hiden=false