I have created a form to be used by others at my company.
In order to submit this form, they must fill in all
mandatory fields. Therefore, I wrote a code using VBA,
that prevents the file from being saved unless all
mandatory fields have been entered. The only way this
works is if the macros are enabled when the user opens the
file. Is there a way to prevent the file from being open
unless the macros are enabled? In other words, can I
prevent this file from being used in they disable the
macros? Any help would be GREATLY appreciated. Thank you!