ribbon

Is there a way to change the colour of Excel/Word icons on the ribbon and quick access bars? Or a download?

Hi, I have written code to hide the ribbon when opening a workbook. The problem I have is two fold... 1. When you open the workbook the first time, it works like a charm, but if you close the file and reopen it, the ribbon doesn't hide like it should. 2. Even though the code is written in...

On the Excel 'Home' ribbon tab, there is a group called 'Number' and it has a combo-box that allows you to quickly change the number format (12 drop-down options). I need to capture the event when someone clicks one of the items from the combo-box in my C# addin. I know that the idMso of the...

Note: This is a cross-posted issue from another forum from August that is not yet resolved. Here is the link to that post. https://www.excelforum.com/excel-programming-vba-macros/1240347-calling-a-macro-in-an-add-in-from-a-different-workbook.html#post5011188 I have a custom ribbon toggle...

Hello, First I must say: I am somewhat new to creating macros and new to creating Excel Add-Ins. Question: I wish to deploy my Excel Add-Ins to certain other corporate users by placing the .xlam file on the network, and giving all users the directions on how to customize their own Excel...

hi all, my question is simple: How to add my own Ribbon / buttons on excel? see a sample: https://imgur.com/a/X5TLlZl i want add this ribbon(personal ribbon) when user open excel, the ribbon stay here.... how to do this? Thanks.

Excel crashed and when it started back up again the ribbon had changed to the new version. The icons have less color and depth, and the tabs are no longer differently colored when selected. I have some visual issues, and this makes it harder for me to find things. I saw an article that said...

Shortly after returning from a trip last week, I copies a bunch of Excel files from my Laptop to my Desktop. Later when I started up Excel (using latest Win 10 & Office 365) on the desktop & immediately noticed all the icons had changed. Not just my custom QAT, but also in all the sections of...

Hi I made custom ribbon for a workbook. The workbook has 6 worksheets in it. Is there a way to have each worksheet with it's own custom ribbon? I sometimes forget which icon is for which sheet !!!!! mike

I've got a workbook I'm trying to modify the ribbon. I have an empty "test" workbook that I used to create the XML code using Ron de Bruin's and other's examples. The empty workbook's ribbon is exactly what I want. Now I copy the XML code into a the target workbook that has all the VBA and...

Hi, I have just upgraded to Excel 2016 (64bit version) and the conditional column feature is missing from the Query Editor/Add Column/General ribbon. I only have Add Custom Column, Add Index Colum and Duplicate Column. Has anyone else encountered this problem?

Hi, I have different groups in my ribbon. I organise them one after another using </group> <group id="GPNOutlook" insertAfterMso="GroupEditingExcel"> <button id="BtOutlook" but is there a way to get this last group placed completely to the right of...

I have tabs in Excel (both hidden and unhidden) I'm trying to export each tab in the workbook to a separate, stand alone workbook. Ideally, I'd have a reports function in the ribbon (like I used to do with pre ribbon excel), that a user could click on and run this and other functions and...

Hi - I created a custom ribbon tab and the keyboard shortcut after creating it defaulted to "Y2". Can someone explain to me how to change it? Maybe to "S" Thanks

Hi, I try to untoglgle a button after use. My xml code is [/URL][/IMG] and I tried this in VBA Sub TbtnManClick(control As IRibbonControl, Pressed As Boolean) Dim Manvalue As Variant Manvalue = InputBox(Range("LgMan"), Range("LgMan"), Range("RngMan")) Range("RngMan") = Manvalue 'Untoggle...

Hello Guys, I have created a custom Ribbon with different groups, say "groupA"; "groupB", "groupC" etc. The top level groups work fine. I need to create sub-groups for groupA. That is when I select groupA (one of the main top tabs), I want to get a set of groups (tabs?) that all belong to...

Hello guys, I have an issue with filter from array..I created custom ribbon and running macro via ribbon (control As IRibbonControl) and filter will find nothing but if I run it from visual basic editor it will find it, do you know what can be the issue?

hi all i have some macros for my Boss, actually i have in each book a button for execute a macro.. but i want add a ribbon and add here my macros.... How to do? thanks

Down to the last little annoyance on the Excel Ribbon bar of this project I just want to hide the little down arrow (top left ribbon bar) for the QAT Customization Menu Not much out there in the way of "Just use this idMso" The little I have found doesnt work - BUT I dont get any erros on the...

I took the IMA Excel Data tutorial offered By Mr. Excel. There was a discussion in the Graphing section about a ribbon tab only available in Excel Office 365 version. This ribbon tab would "suck your data into the web" (@his words) and produce graphing details not available in ordinary versions...