Here's hoow to make the add-in available to other users. Have them go to
Tools menu Add-Ins, click Browse, then find the add-in on the network.
Once selected, it will be checked in the list, and when you click okay it
will be installed. Any toolbars or other UI elements that it builds will be
available so the user can actually use the code.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Sheldon Potolsky" wrote in message
...
I wrote a macro that will recognize eight different filenames and run
the appropriate section of code when one of those eight (Excel) files
are open. My goal is to make this macro available to a few other
users by creating a .xla file and saving it on a folder on a network
drive. I've created this add-in and placed it in the desired folder
on the network drive and I've looked over this Google group and other,
similar groups but still can't put all the pieces together to make
this available to others. I initially thought this would (should?) be
easy to do but apparently it's not. Any/all suggestions would be
appreciated.
Thanks,
Sheldon Potolsky