View Single Post
 
Old 09-17-2013, 08:36 AM
leemoreau leemoreau is offline Windows 8 Office 2013
Novice
 
Join Date: Sep 2013
Posts: 8
leemoreau is on a distinguished road
Default 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!
Reply With Quote