Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

MS Word macro

Jul 22, 2007 12:08PM PDT

I need help in creating a macro in MS Word that will remove the Save feature until all the mandatory fields are put in the form.

Any help will be very much appreciated.

Discussion is locked

- Collapse -
kryptex
Jul 22, 2007 1:25PM PDT
- Collapse -
Why use MS Word ...
Jul 22, 2007 4:55PM PDT

as the form-fill-in application of your choice?

Kees

- Collapse -
MS Word (clarification)
Jul 23, 2007 8:55PM PDT

Hi Everyone,

Sorry I need to clarify a bit. Thanks for your post Tom and Kees Bakker.

I am creating a form within MS Word. All the fields are locked. I have created a macro that will prompt the user that the information is manditory in certain fields. The message only pops up when the user selects that field.

I need to remove the save feature until the manditory fields are filled out because the user can still save the form while skipping the manditory fields (if they were sneaky enough).

I hope this better describes my perdicament.

Hope to hear from you and didn't scare you off with the huge description. I need to know if this is possible or not.

Thanks

- Collapse -
macro on requiring the form field be completed & hiding Save
Sep 25, 2007 4:54AM PDT

Were you able to get your problem fixed and would you be willing to share your macro. I also am tasked with creating a document that has mutiple fill in fields and some of them must be answered before moving to the next.

Additionally, the information from that "initial" fill in form needs to populate fields in another document (addressograph) that will print on each page of mutilple documents that are generated as the product goes through our plant. I have been using links but each time I save the addressograph to a new project (company name) the links are broken. I feel out of my depth here!

Thank you. (a newbie here so just point me in the right direction if answer is already there)

- Collapse -
This really seems ...
Sep 25, 2007 7:10AM PDT

to be a form of mis-use of MS Word. We see it more on this forum, people who seem to think that MS Office is the universal tool for every automation task imaginable. Let me share a secret: it isn't.

Kees

- Collapse -
Using Word for forms and tracking of product.
Sep 25, 2007 8:42AM PDT

I agree, it should be a combination of all Office products, including Access, but unfortunately at this time management feels we can only use Word or Excel. So with limited resources, I am trying to extract as much from Word as possible. Thanks for the response though.

- Collapse -
You know the saying ...
Sep 25, 2007 4:54PM PDT

"If you only have a hammer, everything looks like a nail." Try to assemble a PC using only a hammer and you'll see what I mean.

Good luck with such a management.

Kees