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!

I suspect the macro organiser will do what you want. Developer->Macros- then click on the synchronise button. Macros in Normal template appear in the right hand pane. Select the document you want using the left hand pane then copy across the macros.

Hope that helps.

Are you sure the macros are in the file? By default recorded macros are stored in Normal.dot. in which case the other persons Normal will not have the macros. or the userform.

The macro organiser allows you to copy from one document to another. If you don't want to use the organiser do it directly in the IDE.