Disable save without password

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:

Please Login or Register  to view this content.

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.

Any input would be greatly apreciated.
Thanks in advance!

Filipe

Hi FDibbins

Thanks for the quick reply.

I'm not sure about what that "read only" mode does. Will it allow the user to insert data and run macros? That's kind of the point of this workbook: to be a calculator tool..

Thanks in advance!"

Filipe

Awesome! It works perfectly, and it is much simpler than my previous implementation!

Thank you very much!

Have a nice day

Filipe