custom 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...

Hi I would be really grateful if someone could give me either high-level or detail steps on achieving the following: --- I want to create a file (which I am thinking will be an add-in), that my colleagues can import into their Excel, and when they do, they get a custom ribbon which has the...

Hello, I am learning how to create and work with a custom ribbon in Excel 2019, but clearly have much to learn. I am running Windows 10. I created the XML and callback functions from examples I've seen on various Excel websites. I am not trying to create an add-in. When I open the Excel...

Hi team, I am building a custom ribbon UI Workbook. I am using this (see below) to get Today's Date. Function mydate() mydate = Date End Function + Sub DATE(control As IRibbonControl, ByRef label) label = "" & mydate & "" End Sub Then I am using this (see below) to get Today's Weekday...

Dear all, I use CustomUIEditor to create a buttons tab to open sheets (replace for default sheets tab), but I need active macro content to use buttons. VBA in Modules>Module 1: Sub opensheetA(control As IRibbonControl) Sheets("A").Activate End Sub Custom Ribbon: <customUI...

Hello ! I am using a custom ribbon design, made in XML, for excel (Office 365 version) Recently, the button to insert a pivot table suddenly disappeared on my custom tab in the ribbon. It previously worked without any problem. Related code: <button idMso="PivotTableInsert" label="Vers TCD"/>...

Hello All, I have set up a custom ribbon in an excel file that includes various images as the icons. I was wondering if it is possible to access these images from VBA? I ask because I am working on a tool that will be used by numerous user's from various countries. There are a couple reports...

I have a custom ribbon in this Excel file, and below is a group in my manifest.xml file. I have the the getContent going to a macro called "RDBdynamicMenuContent2." Is there a way to embed MYPath file path into this workbook? Instead of reading the Contacts.txt file from this J drive, can I...

Hi. i'm trying to make custom addin for the below code. I'm new to excel can you please assist how can i customize ribbon in order to run addin. in addition, how can i make addin for this code Sub test() Dim Ary As Variant Dim NewBk As Workbook Ary = Range("A1", Range("A" &...

Hi, I am trying to replicate the behavior of an .xlsm file I have. When I open it, I have a custom tab showing. However, if I go into the "customize ribbon" section, it's not there. There also doesn't seem to be any macro running on the workbook open event. Also looked in quick access toolbars...

I'd like to create something similar to the Excel Styles ribbon item, that looks like this: I thought it might be a gallery, but when I try that element, I get something that looks like this instead: How can I have this box to display the contents, with a button to expand? I may have only...

Hi, I have created a custom ribbon using VBA + XML, which works fine. But while closing the active workbook, i want to remove the ribbon. Which is not happeneing. How do I really remove the ribbon and load it fresh each time the excel is closed and open. Below is the code which I am using...

We need to show macros on the Menu bar/Ribbon in few of our excel files. For this, we have customized the ribbon; and added a group which will have these macros and its working fine. But now this new customized Ribbon is showing up for every excel file that we have, which we do not want. How to...

While testing I'm often switching between EnableEvents True/False so I've added a button to the DEVELOPER tab. Group is "Enable Events" Yellow Smile as icon Label is "Click to Flip" So it ends up reading as "Click to Flip Enable Events" This calls myEnableEvents module in my Personal.xlsb:Sub...

Hi all, I have a custom ribbon in my Excel 2007 workbook. On load my Workbook_activate() function dumps all existing VBA modules and re-loads them from a central repository. This process takes some time (a few seconds). When loading the modules from a local directory - No problem. When loading...

Hi everyone, I've been working with custom Ribbons over the last couple of months and have just started trying to play around with the code that recovers the ribbon object should the vba backend bug out for any reason, thereby allowing the user to continue using the ribbon in the interim...

Hi, I have created a custom ribbon that has macros running through it. Is it possible to change the keyboard shortcuts/hotkeys for this custom ribbon? This could really help all my colleagues that are used to another version of the ribbon. Thanks in advance, Nana

Heres one that has really been bugging me as of late. I created a custom ribbon (Excel 2010) that has a few different macros that I created. These are very simple macros. I want to be able to use these macros for any workbook, but when I click the button on the ribbon it runs the macro and opens...