[dlw]

How do you make macros 'portable' or
remain with the file when sent to someone else?

dlw

[Advertisements]

DLW,
I had some similar problems in the past.

When I investigated it looks like MS will write new macros to normal.dot by default.
When I copied the macro to a module within my own document and removed the code from normal.dot in the VB Explorer window the issue was resolved.

Hope this helps.
Regards
David

[dsm]

DLW,
I had some similar problems in the past.

When I investigated it looks like MS will write new macros to normal.dot by default.
When I copied the macro to a module within my own document and removed the code from normal.dot in the VB Explorer window the issue was resolved.

Hope this helps.
Regards
David

[dlw]

That is correct -- but
When a macro is created a dialog box pops up.
This is where a macro is named and assign shortcut keys. (ctrl+5)
Default is 'normal.doc'.
At the bottom of this box you can select where to store the macro.
I do that. The problem I'm having is after saving the doc;
then reopening it, the shortcut keys do not work.
They are there. I can reassign them with no problems.

I need them to stay with the doc they were created in so
that when I send the doc to someone else, the macros work.

This is my problem. I can't figure out how to have macros
'travel' with the doc.

dlw