| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign Macro to Ribbon Button
In previous versions of XL I could assign a macro to a toolbar button but
HELP in the 2007 version only mentions an object, graphic, or control. Is it poss / how do I assign it to a toolbar button. -- TIA Tim XL 2007, SP1 Vista Student SP2 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Assign Macro to Ribbon Button
Hi tim
If you want to do it for a button on the ribbon you must add RibbonX to the workbook that create the button and in the onAction tell which macro to run. See this page for more info http://www.rondebruin.nl/ribbon.htm BUT: You can add abutton to the QAT if you want and assign a macro Right click on the QAT Choose Customize QAT In the Choose commands from dropdown choose Macros Choose if you want the macro for all documents or only for your workbook in the dropdown next to it Add your macro to the QAT and change the icon with the modify button -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tim" wrote in message ... In previous versions of XL I could assign a macro to a toolbar button but HELP in the 2007 version only mentions an object, graphic, or control. Is it poss / how do I assign it to a toolbar button. -- TIA Tim XL 2007, SP1 Vista Student SP2 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Assign Macro to Ribbon Button
Thanks Ron. It worked fine when the workbook was open but the button
disappeared after closing & reopening, even though I saved it first. Can it stay on the QAT permanently -- TIA Tim "Ron de Bruin" wrote: Hi tim If you want to do it for a button on the ribbon you must add RibbonX to the workbook that create the button and in the onAction tell which macro to run. See this page for more info http://www.rondebruin.nl/ribbon.htm BUT: You can add abutton to the QAT if you want and assign a macro Right click on the QAT Choose Customize QAT In the Choose commands from dropdown choose Macros Choose if you want the macro for all documents or only for your workbook in the dropdown next to it Add your macro to the QAT and change the icon with the modify button -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tim" wrote in message ... In previous versions of XL I could assign a macro to a toolbar button but HELP in the 2007 version only mentions an object, graphic, or control. Is it poss / how do I assign it to a toolbar button. -- TIA Tim XL 2007, SP1 Vista Student SP2 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Assign Macro to Ribbon Button
Hi Tim
I see your problem now Will test more this evening and get back to you I asume that you choose for the workbook only and not for all documents -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tim" wrote in message ... Thanks Ron. It worked fine when the workbook was open but the button disappeared after closing & reopening, even though I saved it first. Can it stay on the QAT permanently -- TIA Tim "Ron de Bruin" wrote: Hi tim If you want to do it for a button on the ribbon you must add RibbonX to the workbook that create the button and in the onAction tell which macro to run. See this page for more info http://www.rondebruin.nl/ribbon.htm BUT: You can add abutton to the QAT if you want and assign a macro Right click on the QAT Choose Customize QAT In the Choose commands from dropdown choose Macros Choose if you want the macro for all documents or only for your workbook in the dropdown next to it Add your macro to the QAT and change the icon with the modify button -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tim" wrote in message ... In previous versions of XL I could assign a macro to a toolbar button but HELP in the 2007 version only mentions an object, graphic, or control. Is it poss / how do I assign it to a toolbar button. -- TIA Tim XL 2007, SP1 Vista Student SP2 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Assign Macro to Ribbon Button
Hi Tim
Working OK in 2010 but not in 2007 SP2 I go test this in SP1 this evening and let you know -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... Hi Tim I see your problem now Will test more this evening and get back to you I asume that you choose for the workbook only and not for all documents -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tim" wrote in message ... Thanks Ron. It worked fine when the workbook was open but the button disappeared after closing & reopening, even though I saved it first. Can it stay on the QAT permanently -- TIA Tim "Ron de Bruin" wrote: Hi tim If you want to do it for a button on the ribbon you must add RibbonX to the workbook that create the button and in the onAction tell which macro to run. See this page for more info http://www.rondebruin.nl/ribbon.htm BUT: You can add abutton to the QAT if you want and assign a macro Right click on the QAT Choose Customize QAT In the Choose commands from dropdown choose Macros Choose if you want the macro for all documents or only for your workbook in the dropdown next to it Add your macro to the QAT and change the icon with the modify button -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tim" wrote in message ... In previous versions of XL I could assign a macro to a toolbar button but HELP in the 2007 version only mentions an object, graphic, or control. Is it poss / how do I assign it to a toolbar button. -- TIA Tim XL 2007, SP1 Vista Student SP2 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Assign Macro to Ribbon Button
Ok, I think we have another SP2 bug here
Working ok on a 2007 machine with now SP and Ok in 2010 I go report this to MS -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... Hi Tim Working OK in 2010 but not in 2007 SP2 I go test this in SP1 this evening and let you know -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... Hi Tim I see your problem now Will test more this evening and get back to you I asume that you choose for the workbook only and not for all documents -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tim" wrote in message ... Thanks Ron. It worked fine when the workbook was open but the button disappeared after closing & reopening, even though I saved it first. Can it stay on the QAT permanently -- TIA Tim "Ron de Bruin" wrote: Hi tim If you want to do it for a button on the ribbon you must add RibbonX to the workbook that create the button and in the onAction tell which macro to run. See this page for more info http://www.rondebruin.nl/ribbon.htm BUT: You can add abutton to the QAT if you want and assign a macro Right click on the QAT Choose Customize QAT In the Choose commands from dropdown choose Macros Choose if you want the macro for all documents or only for your workbook in the dropdown next to it Add your macro to the QAT and change the icon with the modify button -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tim" wrote in message ... In previous versions of XL I could assign a macro to a toolbar button but HELP in the 2007 version only mentions an object, graphic, or control. Is it poss / how do I assign it to a toolbar button. -- TIA Tim XL 2007, SP1 Vista Student SP2 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Assign Macro to Ribbon Button
Ron
Thanks for checking - I'll use a control in the sheet instead Tim "Ron de Bruin" wrote: Ok, I think we have another SP2 bug here Working ok on a 2007 machine with now SP and Ok in 2010 I go report this to MS -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... Hi Tim Working OK in 2010 but not in 2007 SP2 I go test this in SP1 this evening and let you know -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... Hi Tim I see your problem now Will test more this evening and get back to you I asume that you choose for the workbook only and not for all documents -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tim" wrote in message ... Thanks Ron. It worked fine when the workbook was open but the button disappeared after closing & reopening, even though I saved it first. Can it stay on the QAT permanently -- TIA Tim "Ron de Bruin" wrote: Hi tim If you want to do it for a button on the ribbon you must add RibbonX to the workbook that create the button and in the onAction tell which macro to run. See this page for more info http://www.rondebruin.nl/ribbon.htm BUT: You can add abutton to the QAT if you want and assign a macro Right click on the QAT Choose Customize QAT In the Choose commands from dropdown choose Macros Choose if you want the macro for all documents or only for your workbook in the dropdown next to it Add your macro to the QAT and change the icon with the modify button -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Tim" wrote in message ... In previous versions of XL I could assign a macro to a toolbar button but HELP in the 2007 version only mentions an object, graphic, or control. Is it poss / how do I assign it to a toolbar button. -- TIA Tim XL 2007, SP1 Vista Student SP2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| error running macro from Ribbon button | Excel Programming | |||
| How do I Assign Macro to a button? | Charts and Charting in Excel | |||
| Assign macro to button | Excel Programming | |||
| Assign macro to button | Excel Programming | |||
| Assign button to run macro | Excel Programming | |||
Linear Mode
