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.

Uh Oh! Sounds like you need to modify the Ribbon. I have a feeling Ron de
Bruin will be giving you some suggestions on this post. If he doesn't find
this post then try his website.

http://www.rondebruin.nl/tips.htm
--
Cheers,
Ryan


"Rookie_User" wrote:

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.