| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message news  7E897C4-1C99-498C-9393-(E-Mail Removed)...> 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" <(E-Mail Removed)> wrote in message news:A453636D-10E6-4812-A826-(E-Mail Removed)... >> > 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 >> |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > 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" <(E-Mail Removed)> wrote in message news 7E897C4-1C99-498C-9393-(E-Mail Removed)...>> 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" <(E-Mail Removed)> wrote in message news:A453636D-10E6-4812-A826-(E-Mail Removed)... >>> > 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 >>> |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > 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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... >> 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" <(E-Mail Removed)> wrote in message news 7E897C4-1C99-498C-9393-(E-Mail Removed)...>>> 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" <(E-Mail Removed)> wrote in message news:A453636D-10E6-4812-A826-(E-Mail Removed)... >>>> > 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 >>>> |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > > 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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > >> 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" <(E-Mail Removed)> wrote in message news 7E897C4-1C99-498C-9393-(E-Mail Removed)...> >>> 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" <(E-Mail Removed)> wrote in message news:A453636D-10E6-4812-A826-(E-Mail Removed)... > >>>> > 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 > >>>> > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Ribbon - custom button calls macro with argument | Paul Martin | Microsoft Excel Programming | 5 | 26th Nov 2009 02:44 AM |
| error running macro from Ribbon button | debbie@thedivorcehelp.com | Microsoft Excel Programming | 1 | 6th Jan 2008 11:50 AM |
| How to assign a macro to a button | WANNABE | Microsoft Excel Programming | 2 | 2nd Oct 2006 08:25 PM |
| How do I Assign Macro to a button? | =?Utf-8?B?QmVsbEV4Y2Vs?= | Microsoft Excel Charting | 4 | 20th May 2005 07:21 PM |
| Assign macro to button | Frank Kabel | Microsoft Excel Programming | 0 | 24th May 2004 04:03 PM |
