Link an addin macro to a custom button

  • Thread starter Thread starter Chad Cameron
  • Start date Start date
C

Chad Cameron

Hi All,

I created an addin. Now I created a custom button and want to link a marco
from the addin to it. I cannot figure out the proper syntax can someone
help?

Thanks
Chad

Addin is: MyAddin.xla
Module is: Monitoring
Sub is: UpdateRelMovGraph
 
If this is a button on a toolbar...

Saved from a previous post:

Your life will become much simpler if you include code to create the toolbar
when the workbook is opened and include code to destroy the toolbar when the
workbook is closed.

For additions to the worksheet menu bar, I really like the way John Walkenbach
does it in his menumaker workbook:
http://j-walk.com/ss/excel/tips/tip53.htm

Here's how I do it when I want a toolbar:
http://www.contextures.com/xlToolbar02.html
(from Debra Dalgleish's site)

In xl2007, those toolbars and menu modifications will show up under the addins.

And if you use xl2007:

If you want to learn about modifying the ribbon, you can start at Ron de Bruin's
site:
http://www.rondebruin.nl/ribbon.htm
http://www.rondebruin.nl/qat.htm -- For macros for all workbooks (saved as an
addin)
or
http://www.rondebruin.nl/2007addin.htm
 
I guess I was looking way to deep.

Just enter the Sub name. Excel will find it.

Thanks anyways,
You guys/gals always rock
Chad
 
Back
Top