| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
turn macro into add-in
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... -- Mike |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
turn macro into add-in
Hi Mike
Try Dave's example http://www.contextures.com/xlfaqMac.html#NoMacros -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mike Brearley" wrote in message ... 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... -- Mike |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
turn macro into add-in
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 wrote: Hi Mike Try Dave's example http://www.contextures.com/xlfaqMac.html#NoMacros -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mike Brearley" wrote in message ... 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... -- Mike -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
turn macro into add-in
Thanks Dave, time for a new keyboard(Ctrl c is not working very good anymore )
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in message ... 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 wrote: Hi Mike Try Dave's example http://www.contextures.com/xlfaqMac.html#NoMacros -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mike Brearley" wrote in message ... 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... -- Mike -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
turn macro into add-in
Oh, sure. Blame the keyboard!!!!
<vbg Ron de Bruin wrote: Thanks Dave, time for a new keyboard(Ctrl c is not working very good anymore ) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in message ... 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 wrote: Hi Mike Try Dave's example http://www.contextures.com/xlfaqMac.html#NoMacros -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mike Brearley" wrote in message ... 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... -- Mike -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
turn macro into add-in
Oh, sure. Blame the keyboard!!!!
Nobody else in the room to blame <g -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in message ... Oh, sure. Blame the keyboard!!!! <vbg Ron de Bruin wrote: Thanks Dave, time for a new keyboard(Ctrl c is not working very good anymore ) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in message ... 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 wrote: Hi Mike Try Dave's example http://www.contextures.com/xlfaqMac.html#NoMacros -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mike Brearley" wrote in message ... 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... -- Mike -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
turn macro into add-in
Time to get a cat--even one of those imaginary ones!
Ron de Bruin wrote: Oh, sure. Blame the keyboard!!!! Nobody else in the room to blame <g -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in message ... Oh, sure. Blame the keyboard!!!! <vbg Ron de Bruin wrote: Thanks Dave, time for a new keyboard(Ctrl c is not working very good anymore ) -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Dave Peterson" wrote in message ... 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 wrote: Hi Mike Try Dave's example http://www.contextures.com/xlfaqMac.html#NoMacros -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Mike Brearley" wrote in message ... 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... -- Mike -- Dave Peterson -- Dave Peterson -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
turn macro into add-in
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 "Mike Brearley" wrote in message ... 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... -- Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I turn the Macro Stop Recording Toolbar on and off? | Excel Discussion (Misc queries) | |||
| Macro to turn on/off rowliner? | Excel Discussion (Misc queries) | |||
| How to do a macro for IF cell b1 is < b3 turn b1 red? | Excel Discussion (Misc queries) | |||
| How do I set up a macro to turn on Windows in Taskbar in Excel 200 | Excel Discussion (Misc queries) | |||
| Turn off warnings in Macro | Excel Worksheet Functions | |||
Linear Mode
