user/passwords

[mr jamez]

Hi, just a basic question and hopefully a simple solution. Basically I
want to have a user/pass box that, when the data is correct, takes you
to a worksheet. I have searched the forums/site and havent found
anothing usefull. I have tried using macros and cutting up some vb code
that looked..interesting..but none worked.

TIA

 

[mr jamez]

Well its just a as level ict project, very easy and it doesnt matte
about security, this just had me stumped. Though in the end i foun
some code on this site and cut it up to:

Dim Pwd, Res
Pwd = "james"
Res = InputBox("Please Enter Password")
If Res <> Pwd Then Exit Sub
Sheets("Manager").Select
End Sub

Not sure if every bit is needed, but it works :