![]() |
|
|
|
#1
|
|||
|
|||
|
I still can't find a way to get custom icons on the QAT that call VBA macros.
I've been developing Microsoft code since 1994 and am certified in Visual Basic 5.0. I did finally get a tab to show up in the ribbon with my icons loaded but they don't work. I'm getting an error saying: 'Wrong number of arguments or invalid property assignment'. The 'macros' are simply VBA public scoped Sub procedures that put the cursor on a specific line in the doc depending on which 'macro' was called. The procs don't have arguments and no properties are changed. I should state that they run if I pull them up in the Developer tab or hit the shortcut key to them. I also had them on the QAT with a stock icon. The macros run just fine. Before I attempt to get these into the QAT, how do I make these VBA macros run? Code:
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="RibbonControl.Onload">
<ribbon>
<tabs>
<tab id="TabNav1" label="Inspectagator Sections" >
<group id="customGroup" label="Custom Group">
<button id="btngoToRoofing" label="Roofing" image="icoRF" onAction="goToRoofing"/>
<button id="btngoToExterior" label="Exterior" image="icoEX" onAction="goToExterior"/>
<button id="btngoToGarage" label="Garage" image="icoGG" onAction="goToGarage"/>
<button id="btngoToPlumbing" label="Plumbing" image="icoPL" onAction="goToPlumbing"/>
<button id="btngoToAttic" label="Attic" image="icoAT" onAction="goToAttic"/>
<button id="btngoToElectrical" label="Electrical" image="icoEL" onAction="goToElectrical"/>
<button id="btngoToMechanical" label="Mechanical" image="icoME" onAction="goToMechanical"/>
<button id="btngoToKitchen" label="Kitchen" image="icoKI" onAction="goToKitchen"/>
<button id="btngoToInterior" label="Interior" image="icoIN" onAction="goToInterior"/>
<button id="btngoToBedrooms" label="Bedrooms" image="icoBD" onAction="goToBedrooms"/>
<button id="btngoToBathrooms" label="Bathrooms" image="icoBT" onAction="goToBathrooms"/>
<button id="btngoToPool" label="Pool" image="icoPO" onAction="goToPool"/>
</group>
</tab>
</tabs>
</ribbon>
</customUI>
They still throw the same useless error. |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Visio 2016 diagrams embeded in word 2016 not drawing properly
|
stubbo66 | Visio | 2 | 08-24-2016 05:58 PM |
make a .csv file of Address Book Outlook 2016
|
topdog | Outlook | 6 | 04-19-2016 11:39 AM |
| Master slide placeholder text - make completely custom for each layout | lhulmef | PowerPoint | 1 | 03-25-2015 03:03 PM |
How to make Quick Access Toolbar icons smaller in XP
|
WaltR | Word | 1 | 04-09-2012 11:42 AM |
| outlook 2003 custom email rule icons | pgasparr | Outlook | 0 | 06-29-2011 06:16 AM |