user/passwords

  • Thread starter Thread starter mr jamez
  • Start date Start date
M

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 :)
 
The user is offered the choice to disable macros or can hold down the shift
key when the workbook is opened. Your macro never runs. No password is
needed.

When you save a workbook, you can specify a password. However, once the
user has access to the workbook, they can do a saveAs to a different name
and not specify a password - providing an unprotected copy.
 
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 :
 
Back
Top