View Single Post
 
Old 05-17-2016, 06:02 AM
Charles Kenyon Charles Kenyon is offline Windows 8 Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Try removing "control as IRibbonControl" from your vba. That does not work on QAT icons but only on Ribbon buttons.

I ran into the obverse problem a while back where it would run from a button on the QAT or by calling the macro directly when the template was loaded as a global but would not run from the ribbon button.

See Wrong number of arguments or invalid property assignment error message in Ribbon customization

By the way, I find using the UI as the principle way to modify the QAT easier than xml. Then I may modify the XML to add tooltips and supertips or change the icon.
Reply With Quote