Excel vba userform - code for command button not working

I am attempting a work around for password protecting sheet 3. Sheets 1 & 2 are hidden, when clicking on the desktop short cut the user will go directly to the user form(this is currently disabled for testing). I have a "enter password" text box and a "login button" on the userform. The code is written for that button but does not work. What I need is when the currect password is entered that person can then leave the userform and go directly to sheet 3. If the password is incorrect that user will stay at the userform for data entry. Also the code is normally password protected but has been disabled until going live. HELP!

Please Login or Register  to view this content.

Hi, maybe this is what you are looking for....

Please Login or Register  to view this content.

Workbook_BeforeClose event seems redundant since you are not showing your application on Workbook_Open.

Does this help?