customui

Hello, I do not know if in this section is the right place to ask about this, then please let me know if I am wrong. So, I have the following code in my Office RibbonX Editor and this is working properly on Windows, but on Mac the customized ribbon does not initializate. if I set <ribbon...

I had a problem that starting Excel from Python whacks the Custom ribbon. I eventually got code that does the job. Starting Excel from Python does not whack the Custom ribbon anymore. With complements of losing the state of the global IRibbonUI ribbon object This was written some years ago and...

I have a custom ribbon in Excel with macros assigned to it. One set of macros does just sheet/column formatting, sort data etc. Normal Excel stuff. Those all works. Then I have two specific macros that removes the custom ribbon completely when they execute. Well, after the executed the Custom...

I'm in need of some expert help, i have a workbook where i need to only allow Paste Special Values. This particular workbook as special formatting ect. that I don't want overwritten when a user does a standard paste vs. paste values. I tired some VBA but couldn't get that to work quite right...

I have a macro that I used to input numbers in cells/textboxes in my sheet. however, i am puzzled as to how i would declare my variable instead of "As Double" How can I add text rather than an integer? Public Sub ToQuote_Change(control As IRibbonControl, text As String) 'Changes the To: in...

I have a fairly complex ribbon tab for an application that looks quite good when viewed fullscreen on a 1024x768 display. But as soon as the window size gets smaller than that, all of the groups in the tab collapse to icons that must be clicked to display the controls. The default ribbon tabs...

What is the better practice? I am learning how to write an excel add-in to provide User Defined Functions (UDF). On the initial pass, I had the MacroOptions hard coded into the VBA code. In this test version, I put the input for the MacroOptions into a sheet on the Add-in sheet. The code is...

I have an excel add-in that uses the customui to add a tab to Excel for users. It has been working great for both Excel 2010 and Excel 2013. However, yesterday, after what appears to be an update on our company computers, the Excel 2010 users do not see the custom tab. Excel 2013 users are fine...

Hello all, I have recently encountered a problem when I share my customizedribbon and respective macros with another user. I have several Macros in my PERSONAL project in excel and I created some buttons manually to call these macros. Apparently, when I created the buttons, each button was...

Hi, I have written the customUI XML for an Excel workbook. There are few onAction callback functions i have written for the commands, for e.g. for idMso=ChartEditDataSource there is an onAction=DatasourceProtection written in the VBA. Now the problem statement : somebody can just rename the...

Hi Everyone, I've been a long time user of MrExcel and all sorts of ideas and suggestions and fixes... for that I say a hearty THANK YOU! Today however I can't seem to find the answers I seek. I have become well versed in Ron de Bruin's examples, and I have my custom ribbon built, and...

I have a file where I create my own custom tab group using the Custom UI Editor. The tab group does not display when opened with Excel 2013. I've read about the differences between 2007 and 2010/2013 and it seems like there should be no issue with this file. The XML code is added an an 'Office...

Howdy Asked this of Ron via twitter, but I imagine he's a busy body so thought I'd try here as well. I've set up customUI ribbon tab with some galleries that'll insert some common pictures I use all the time, to save me some time. The plan is then to turn this into an add-in. I want the...

Hi All, I'm relatively new to the CustomUI stuff. Today I created a custom Tab in Ribbon with a button and a dropDown (in Excel 2010). The XML looks like below - <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon> <tabs> <tab id="MyTab" label="MyTab"...