MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form


Joined
Jan 11, 2020
Messages
2
Reaction score
0
Help please...

I have a MS365 Word fill-in Form created that we don't want our users to be able to SAVE. We just want user to be able to email filled-in form.

- I have a working macro that takes the filled in form and emails it, however it saves the data on the original form automatically.
- Creating a template also forces user to save doc prior to email sending.

So, I believe my only option is NOT using a Template, but using the document and creating a "CLEAR FORM" macro Button which will allow user to start with a clean form upon opening.

Word FORM includes the following which would need to be cleared with this macro:
  • Text boxes
  • Check boxes
  • Drop-down lists
  • Date picker fields
FYI: I'm not an expert at coding, yet I've tried several attempts, without the desired results.

Can this even be done in a Word Form?
 
Ad

Advertisements

macropod

Microsoft MVP
Joined
Mar 2, 2012
Messages
478
Reaction score
42
Instead of using a document for this, you should be using a proper Word template. That way, when the user saves the filled-in document, the template won't get overwritten. No code required.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top