PDA

View Full Version : Save on Click through userform



nigel9097
01-11-2017, 01:35 AM
Hi,

I have created a macro enabled word document which uses a userform. Up to now everything works great but I need it to do the following, could anybody help please?

When the submit button is clicked, save the document as a word document that is not macro enabled, so when the user reopens that document the userform does not re-appear.

Any help appreciated

Kind Regards,

Nigel

gmaxey
01-11-2017, 08:06 AM
Why don't you just put your form and code in a macro enabled template with an autonew macro to call your form when you create the new unsaved document?