ribbon

An odd one I have a file with several macros in it, when I used buttons on the worksheet an assign macros then when I save as the file(It is under development, so I regularly save new version with a new name) it works fine. I have now removed the button on the worksheet and moved all the...

Hi can someone give me a example of a chekbox on the ribbon What want is that the user can chek or uncheck the checkbox and that the next time he open the file the checkbox is so like the user have set the checkbox. And by reopen the file how to control the state of the checkbox Greetings Glenn

Is it possible to import other macros in the ribbon, than the standard ones from the personal macro book. The macro should remain in the ribbon. (I have some code in one VB Module saved on my drive). What is the easiest way of opening it in a standard way? If it could always be in the ribbon...

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

Is there a way to limit the display of combobox items in the Ribbon? Or if I have 1,000 items- will it will show a list the height of my screen with a scrollbar?

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.

Hi, Is there a way to enable a ribbon button if a column or row is selected and disable the same button if row or column is not selected.

Hi guys. Is there a way with automatically showing an .xlam file that you have created in the ribbon without going through the Options>Addins>Browse? A previous addin I have used automatically shows itself once I open it from the desktop, in the ribbon without going through the hassle. Thanks...

Hello, I have been working with a sheet for sometime now, and I've been able to configure a data sheet that has lots of macros. I've been using a seperate sheet within the data sheet to activate macros, but it occurred to me to make my own ribbon instead. Is there a way to ensure that the...

Dear Mr. Excel, I made a customized ribbon in excel, where a number of standard buttons have been added for my dashboard. Now I have written a macro that I also want to add in the customized ribbon. In CustomUIEditor I added: <!-- BUTTON: Macro--> <group...

Hi, I would like to addin to the ribbon which i failed on my all effort.. can anyone help how to add that on ribbon and execute. Thanks in advance

Hi dear members, I just thought I would share with you here this very small and simple vba function that I recently wrote for switching ribbon tabs. Option Explicit Function ActivateRibbonTab(ByVal TabName As String) As Boolean Const CHILDID_SELF = 0&, NAVDIR_FIRSTCHILD = 7&, NAVDIR_NEXT...

Hello, I've been working with a series of Macros for a little while now. I've been setting up little buttons on a page so they are accessible to a user. It occurred to me how much easier it would be to just create a macro and add it to a ribbon. And it's pretty amazing to have. There is one...

Hi I am trying to enable a ribbon button if a column is selected, I know I need to use the on selection change event but not sure how I do this, Can someone help please

Hi, I have created a toggle button in xml which works ok but what I would like to do is enable two other buttons on the ribbon If toggle button is pressed and disable the same two buttons when toggle is un pressed. Can some one help with this please?

In Excel 2016 How Do I add certain tools to my ribbon? Every single time I try to use certain tools in excel, they do not appear in my ribbon for me to use. Why? and how can I add the tools to my ribbon? Thank you!

This might be a stupid question, but how do I update my Excel 2016 so that it has the new "Get & Transform Data" Data ribbon tab instead of the old "Get External data" tab?

I'm trying to write some code to cause the ribbon to disappear and also try to get the menu to disappear on startup. I can get 'CommandBars.ExecuteMso "MinimizeRibbon"' to work just fine anywhere EXCEPT the WorkBook Open event. Any ideas for this and to hide the Excel menu on startup?

Hi all, I'd like to find a way to add RibbonX code to an existing Excel file (.xlsm) using VBA instead of the Custom UI Editor. The reason for this is that we have a workbook stored on SharePoint and accessed by many users that occasionally has its Custom Ribbon removed from the file. I've...

Can I hide the Ribbon when a sheet is Activated and unhide it when the sheet is deactivated. I only want to do this on one of my sheets.