Pete
08-10-2008, 12:20 PM
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.......
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.......