On May 16, 12:13*pm, "Norman Jones"
wrote:
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)?- Hide quoted text -
- Show quoted text -
And, in addition to Norman's response, have a look at Ken Puls' info
regarding deploying an add-in across a network. I use a modified
version of this code almost daily.
http://www.excelguru.ca/node/45