Help-how to install a macro for everyone to use

R

Rookie_User

This may not be in the right category but I thought I would try here. I have
a macro that I want to send to 120 people. These people are located in many
areas of the country and DO NOT use Excel very often. Originally with 2003,
we created an addin that had a custom toolbar with a button assigned to a
macro. They would double click the addin and then when they load their CSV
file, the custom button would format it appropriately.

This addin would also work with 2007, copy addin to c:\ double click and
somehow it created a custom menu with the button on it and it worked.

NOW we have updated the macro and our confused on what is the best possible
way to distribute the macro in 2007. Addins don't seem to work as previously
and we don't see any custom toolbar option besides the quick access toolbar.

I am looking for any suggested method to easily distribute this macro to our
territory managers.

Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top