Quote:
Originally Posted by Cold in Skagway
If I did succeed it getting this to work, I would have to save it as a ".doxm" correct?
Would the person(s) wanting to use this form also have to have the macro installed and have to run it every time they fill in the info, or would it be automatic?
Please understand, the less clicks and fiddling around to get the form filled out and printed with the info the better.
|
If you were to save the document as a dotm template, double-clicking on that would allow the user to create a docx file that has full access to the code that drives the process. Alternatively, if the users are unlikely to have access to the template, you could distribute a docm document such as the one attached to post #2.
Whether the macro runs automatically in the case of a docm document largely depends on the user's macro security settings. With the template approach, that's not an issue.
As for "the less clicks and fiddling around to get the form filled out", all the user need do is select the appropriate entry from the dropdown and the output will be generated/updated as soon as the dropdown is exited. It could hardly be any simpler than that.