ribbon customization

Hi All, I was wondering if it is possible to loop through all controls in the Ribbon, including custom add-ins, and get the IDs? What I am ultimately trying to do is add a control group to a tab which is not from native Excel but another add-in that I do not have source to. If I can get the...

Hi to everyone! I created 2 custom toggle buttons with Office RibbonX Editor. So my question is hot to connect them - i mean when i toggle one button - other one should be untoggled. Here is some code from Office RibbonX Editor: <group id="customGroup4" label="Фільтрація за датою">...

Is there a way to add a macro to a large group of people's ribbons without going in and adding it individually to each person's machine? My goal is to be able to write a macro in my personal workbook and then add it to the ribbon of workers at the company I work at. All without going to each...

Hi Guys, Hoping for some help on this one. I have a custom Tab on My Excel Ribbon titled 'Macros' - This has alot of my everyday macros I like to use that are saved in my personal workbook. - I have never had any issue adding macros to my custom tab on the Ribbon. However recently when I...

I'm stumped. I have a custom ribbon created via the Office RibbonX Editor. I have 3 custom tabs with buttons, and textboxes. These have all been working for 2 months - thanks to the help of many people smarter than me on the web. But now when I open the workbook, I get this error - twice...

i'm fairly new to Excel VB, it would be great if you can provide your input on following questions: 1. if we make customize ribbon it loads from excel startup folder, is it possible to load it from a different location? 2. if i have a addin, how can i transform it to customize ribbon and load...

Hi, I have built a customized ribbon in VBA. This worked well and suddenly it disappeared... In VBA I added "loss of state" and the physical address of the ribbon, but how can I retrieve it now? Many thanks for your quick reply.

Hello, I am really tired to tried to find a way to edit/customize the ribbon, I need the clear contents button be accessible without having to open the dropdown list every time. Thanks in advance...

Was hoping someone might have an answer for this... I am new to working with macros and customized ribbons and have a Word document that was shared with me but I believe it will be more functional being used in Excel. Mostly to do with formatting and how the macros seem to work. I have the...

Hello.. This is my first time posting a question so I'm sorry if I don't follow protocol exactly. I'll try. We are using Windows7 with Excel 2007. We have old code from excel 2003 and earlier that was adding a msoControlPopup with other sub-controls using the code below: Set HelpMenu =...

I'm just finalizing a VBA application I've been working on for some time. I was about to make a Table of Contents sheet with links to various sheets and a bunch of buttons to run various macros I've written when it occurred to me it would be really nice to have instead a tab on the ribbon where...

Yesterday, I noticed that my custom "Close without Saving" button stopped working. I checked the VBA editor and my Personal workbook was missing and all of my personal macros were gone. I restarted excel, same issue. Rebooted my machine and they re-appeared. Not sure how what happened, but...

I found this very helpful video on the Contextures site http://youtu.be/eJslb49T0Bk does anyone no how to make that customized ribbon or know of a video on it .

Hi All, I have recently migrated to Excel 2010 from Excel 2003. In Excel 2003, I created an Add-In that had 20 bespoke macros in it. Everytime a user opened Excel 2003, the Add-In was deleted and re-installed (from a shared drive) using VBA coding within the "Personal.xls" workbook. This...

Dear All, Is it possible to edit and/or add extra symbols for the macro buttons? I mean to extended what the pallet offers Cutomsie Ribbon > Rename (As it is used to be before ribbon age with the ultra primitive built in symbol editor) Many thanks in advance,

I have developed a customized ribbon (AddIn) in excel, thanks to all the free tutorials available on the net. But now i want to take it up to the next level, i am facing a challenge that how should i build a button which shows an image(pic) with the screentip/supertip as i hover the button...

Hello Everyone, Is it possible to show only the File tab from the ribbon and hide all the other tabs?

Hi, I've been battleing over this for sometime now. I've created a custom ribbon with a range of buttons and dropdown menus. So far I have been able to get code to run when using OnAction commands for buttons, but I am now trying to use Callbacks to change the enabled state of a dropdown or...

I have only very VERY basic knowledge of VBA, and none of XML. I had a custom toolbar in Excel 2003, with button images I'd created myself, linked to macros I'd created. I'm trying to achieve this in 2007. I've successfully got my macros into my 2007 "PERSONAL.XLSB" workbook (by simply copying...

I have a macro which I assigned to a custom butoon in Excel 2003. This macro was run by many users in my organization. I would like to duplicate the funcationality in Excel 2007. I have created the xml code to add a custom button to the Ribbon using the CustomUI Editor. This works well. I...