Macros disappear

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Prashanth KR - 15 May 2008 15:05 GMT

Hi,

I have recorded a Macro in Word 2003 with a keyboard shortcut CTRL+Shift+N,
which works perfectly on my system.

I have two questions:
1. I cannot view my own macros on my system when I reopen the document, but
the macro works.
2. When I send the same document to another person, the macro does not work,
neither it shows the macro when I press Alt+F8.

I have checked the Macros security level on both the PC's and it says
"Medium" which is fine.

Kindly help,
Prashanth KR.

Reply to this Message

Klaus Linke - 15 May 2008 17:03 GMT

Hi,

Macros you record are stored in your Normal.dot ... in a module called
"NewMacros".

You could copy the whole module into the document using the organizer (Tools

> Options > Templates and Add-Ins), or copy/paste the macro in the VBA

editor from "NewMacros" into the document's "ThisDocument" module (which
always exists) or some new module in the document.
You'd then need to reassign the keyboard shortcut too.

Regards,
Klaus

> Hi,
>
[quoted text clipped - 15 lines]
> Kindly help,
> Prashanth KR.

Reply to this Message