How do I save a Word file with a macro for distribution?
I made a word document and then added a bunch of docvariables, then used visual basic to create a userform. I save it on my desktop and works fine. When I open it, I click view, macros and then select the ShowForm macro and Run and it brings up the userform. However when I email the file to someone, they open it and get the standard "Enable macros?" question, but when they click View > Macros there's nothing shown there. If they go ALT-F11 to open Visual Basic, there's no userform etc shown. I did see one message about enabling macros and it showed the dotm I think it was file type but the path was a location on my own computer.
Maybe I'm missing the obvious, but how can I email a word document to someone so that they can just load it, and click View > Macros and then run the userform the same way I would? Thanks!
|