Code Help

  • Thread starter Thread starter Markus
  • Start date Start date
M

Markus

How can I write a VB code to a command button that will
bring up a password prompt and only open another sheet if
the user enters the correct password?
Thanks
 
Will this work?

Sub askpassword()
ans = InputBox("Enter Password")
If UCase(ans) <> "JOE" Then Exit Sub
Sheets("Joe").Select
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

code problem not working HELP 4
Macro to prompt for password to unprotect worksheets 2
Prevent User from Changing Password 2
How to bypass password when pasting FROM a protected workbook 3
How to hide password? 1
Code based on opening Read Only or not 4
Help with VB Script 4
Unprotect worksheet method in VBA 2

Back
Top