Hi everyone.
First post, but I come here a lot to learn from you guys. I came across a few awesome bits of code, and have been trying to frankenstein it together.
The purpose is to stop users to save the excel file. When the user tries to save, a userform appears asking for a password. If the password is correct, the workbook is saved. If the password is incorrect, a message appears saying "Wrong Password".
However, for some reason, it still saves the workbook when the password is incorrect... Here is the code:
The code above clears the texbox, and then makes the userform3 appear before saving. The userform has a textbox, a commandbutton and an exit button.Please Login or Register to view this content.
The code above is what happens when you press the command button.Please Login or Register to view this content.
The code above does not allow to save when exit is pressed.Please Login or Register to view this content.
The code above makes pressing enter the same as clicking the command button.Please Login or Register to view this content.
Any input would be greatly apreciated.
Thanks in advance!
Filipe
Bookmarks