#1
|
|||
|
|||
Type Mismatch when RibbonX applying crtx to Chart?
Apologies, I just realised what's wrong! Should have talked to my duck first...
Sub ApplyDoughnut(control As IRibbonControl) ActiveChart.ApplyChartTemplate "Doughnut.crtx" End Sub The red bit is what it shoul be, I had somehow copied "ribbon As IRibbonUI" instead. Please feel free to delete or leave up as a lesson to others. ORIGINAL POST BELOW: Hi All I'm a newbie with VBA and RibbonX so probably I am missing something completely obvious! I would really appreciate any help - I've previously created simple custom ribbons with button calling macros or applying styles, but I don't know how to handle this issue. Excel 2010 on Windows 7 Enterprise. Editing the CustomUI part using XML Notepad. I have created several custom chart templates and saved them in the default C:\Users/[username]/AppData/Roaming/Microsoft/Templates/Charts/ directory. I want a button on my custom ribbon for each of these chart templates which will apply the template to the selected chart. The XML looks like this: Code:
<group id="ChartFormats" label="Custom chart formats"> <button id="DoughnutChart" label="Doughnut Chart" size="large" imageMso="ChartTypeOtherInsertGallery" onAction="ApplyDoughnut"/> </group> Code:
Public MyRibbon As IRibbonUI Sub MyRibbonInit(ribbon As IRibbonUI) Set MyRibbon = ribbon End Sub Sub ApplyDoughnut(ribbon As IRibbonUI) ActiveChart.ApplyChartTemplate "Doughnut.crtx" End Sub But when I click on the button to run ApplyDoughnut, I get a Type Mismatch error. Including the full filepath to the crtx file doesn't help. Is there some sort of interface or class or something (you can see how much of a newbie I am, please be gentle!) that I need to declare somewhere? Any help would be really, really appreciated. Last edited by Elinor; 06-03-2016 at 06:51 AM. Reason: Solved it.... |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Name mismatch b/n two columns | hiruy | Excel | 1 | 12-18-2015 07:14 AM |
Problem with RibbonX showLabel=false | NobodysPerfect | Word | 7 | 01-31-2015 02:18 PM |
VBA in Excel: Add a new Word Document on Template (Type Mismatch Error)) | tinfanide | Excel Programming | 1 | 03-29-2012 09:10 AM |
[Mismatch] Help needed!!!!!!!! | rockfielder | Word | 3 | 08-25-2011 11:45 AM |
Resolution mismatch | Adforum | PowerPoint | 5 | 05-25-2011 12:24 PM |