Word 97 macro not seen by others

[itfellow]

Hi all,

I have a Word 97 doc which is a fillable form. I set the "on exit" property for the last field to run a macro that I created, which then clears out the form.

Everything works wonderfully, but when I stick the file out in a share (where everyone has modify rights to the file, directory and share) and users open it from their desktops, the macro does not work. In fact, the form field properties for the last field where the macro should be appear empty, even though when the users initially open the doc, it recognizes the presence of a macro by popping up the window to "disable macros", "enable macros" or "do not open" (the users select "enable macros").

However, if I open the same doc on the share from my desktop, everything works just fine. I am at a loss to explain this. Any ideas?

 

[BlueHorizon]

Hi,
Did you store the macro in the document or on your Normal.dot? If it's on your Normal.dot, then other users can't access it. If it's stored with the document, it should travel to other users. This is a choice when creating the macro using the Macro dialog box.
HTH,

Best,
Blue Horizon

http://www.bluehorizontraining.com

 

[fumei]

Exactly. Copy the macro into the document.

1. Open the VBE (Alt-F11)
2. Find the code module in normal.dot with your macro. If you recorded the macro, this is likely NewMacros under Modules. Click the + sign beside Modules, double click NewMacros. Find your macro code and copy it.
3. Rename the macro - just in case.
4. Open the ThisDocument code module of your document.
5. Paste the macro code into ThisDocument.

Send a test document out. If it works OK, and it should, go back and delete the macro from normal.dot.


Gerry

 

[itfellow]

Bluehorizon and Fumei,

Thank you both - you were exactly right. I copied the code into the document area and it worked like a charm.