turn macro into add-in

[Mike Brearley]

I have a macro using vbscript that I would like to turn into an add-in so I
can put it on multiple computers. I'd also like to add a button on the
toolbar that will launch the code. Is there an easy way to do so?

Thanks...

 

[Ron de Bruin]

Hi Mike

Try Dave's example
http://www.contextures.com/xlfaqMac.html#NoMacros

 

[Dave Peterson]

I bet Ron meant the second one:

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)

 

[Ron de Bruin]

Thanks Dave, time for a new keyboard(Ctrl c is not working very good anymore )

 

[Dave Peterson]

Oh, sure. Blame the keyboard!!!!

<vbg>

Thanks Dave, time for a new keyboard(Ctrl c is not working very good anymore )

 

[Ron de Bruin]

Oh, sure. Blame the keyboard!!!!

Nobody else in the room to blame <g>

 

[Dave Peterson]

Time to get a cat--even one of those imaginary ones!

Oh, sure. Blame the keyboard!!!!

Nobody else in the room to blame <g>

 

[Harald Staff]

Hi Mike

Just another thing to consider: Excel 2007 (and probably all upcoming
versions) do not have toolbars anymore. See Ron's site (
http://www.rondebruin.nl/ribbon.htm )on how to add buttons to the new
interface.

Best wishes Harald