Prevent Save by User Unless Condition is Met, but HOW DO I SAVE??

[sryan429]

Hi there,
I have a code that I am using to prevent a user from saving an excel file until all required fields have been populated. The code works, but it works too well... I can't figure out how I CAN save the file so it can be used by others. Any thoughts? I need to save it in it's blank state to serve as a form. Thanks!

Code is pasted within "This Workook" in vba editor

Please Login or Register  to view this content.

[JLGWhiz]

Assuming the file was saved to a default directory prior to a non-compliant user trying to save it, it would still be residing in the default file without the non-compliant changes. Ergo, you could just close the open file without saving.

Please Login or Register  to view this content.

Your original file will still be intact.

[sryan429]

Hi JLGWhiz,
Once I insert the code I am unable to save the file myself since there the fields are blank. The previous version does not include vba condition. I need to get the file saved with the vba inserted and the condition not met. Basically I need some master override as the form designer. The form will be blank for users so they can fill out and only save once all fields complete. Does that help?

[WideBoyDixon]

Alt+F11 to bring up the VBA editor then Ctrl+G to go to the immediate window. Type this and hit return:

Please Login or Register  to view this content.

That should print your username as recognised by Excel. Now change your macro:

Please Login or Register  to view this content.

Replace "wbd" with whatever your username is. This allows you to override the save check.

WBD

[sryan429]

thank you much for the reply and fix!