custom menu items linked to 'remote' macro

[Geo]

I'd like to add a custom menu item (easy enough), but want the macro to point
to macro located in a file on the network. The reason for this is so that
many users will use this macro and I dont want to have to maintain each
user's normal.dot file.

I want a single source for the macro, so that users can benefit from
updates/bug fixes/revs etc without having to copy the code each time there's
a revision. It seems the problem is that the only macros that show up as
available for menu items are located in the normal.dot file (stored locally).

I program Excel quite a bit, and it's easy enough to link a menu item to a
networked spreadsheet. But it seems this option is not available to Word? If
not, are there any elegant solutions/workarounds?

 

[Jonathan West]

Hi Geo,

This article will help you

Distributing macros to other users
http://word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm