View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones[_2_] Norman Jones[_2_] is offline
external usenet poster
 
Posts: 421
Default Macro available to multiple users via network

Hi A,

In addition to JW's excellent suggestion, try
placing the Add-in in a common network
share. Then the add-in can be installed, as
suggested by JW, via Tools | Addins. This
will also make maintenence easier.

If you are new to the world of add-in
creation, distribution and installation, see
Jan Karel Pieterse's excellent tutorial at

Creating An Add-in From An Excel Macro.
http://www.jkp-ads.com/Articles/DistributeMacro00.htm



---
Regards.
Norman


"ABlevins" wrote in message
...
I need to make a macro available to multiple users via our office network.
I
can create the macro easily using the Macro Recorder; but, I can't access
the
the Personal.xls folder of all the users who need to use it. Any
suggestions
on how to share the macro (while protecting it from accidental tampering
by
others)?