-
Solved: password lock a worksheet using a userform
see attached workbook
Hi
Need to password proect one worksheet in the workbook. so if the user click the tab "Pricing Template" then they are prompt to enter a password.
Sequence
1. If they press ok button with out entering password msg box" Invaild or Incorrect Password Entered" - Try Again!
2. If they press cancel then exit
3. Correct password open up worksheet.
4. If they switch worksheet(s) then the password must be enter again to access worksheet once again..
The password for the workbook is Phoenix if asked - User frm is frm_Pricing_Template.......
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules