Distributing my macro to everyone in my office

C

carl0s66

Hi 1st post :)

As the title states I have an excel macro I need to distribute to th
rest of my office, I have tried to save the macro as an excel add-i
but (then including it in the add ins loaded and restarting excel)
When I open the add in I have no way of running the macros, do I hav
to create an extra button on the toolbar as part of an automaticall
run macro??

Or is there another way involving the default template for all users i
the office?

Or creating a new template?

If anyone knows how to do this type of thing or has similar experienc
I would appreciate any advice.

Many thanks,
Carlo
 
D

Dave Peterson

You could put your addin into a network folder and let the users point to that
addin (via tools|addins|browse).

Then you'll only have one version of the workbook to update--you won't have to
make everyone update their own copies.

You can add some options to the menubar. I like the way John Walkenbach did it
in his menumaker.xls workbook.
http://j-walk.com/ss/excel/tips/tip53.htm

It's easy to update and looks really professional.

And for toolbars, I like this:
http://groups.google.com/[email protected]
 
Top