ribbon

Good afternoon all! I am working on a workbook where I have been asked to lock down or turn off a lot of items (formula bar, ribbon, headings, tabs, copy/paste, dragging, etc.). I have this working but I have had to go back and do edits and other updates as changes are requested which causes a...

Thanks in advance for your assistance. I have produced a Leave Diary builder in Excel 2010 which has a custom ribbon tab. Based on the name of the workbook, I show or hide certain buttons on the custom tab. When I open the workbook it shows only the one Build button on the custom tab. If...

Hi Everyone, I'm having an issue on occasion where macros that are written in the vba editor are not showing up in the macro ribbon so I can assign it to a button? Whats strange to me is the exact same macro will show just fine in a different workbook? It is a macro enabled workbook and I have...

Hello I am working with Volpi's Fox Team Matrix and XNumbers add-ins that were not upgraded for Excel's ribbon versions. I created manually new tabs and groups to assign the macros that show the userforms. However, I did not find anywhere how to it using VBA to automate the process, so I am...

Hi, I have created an Excel template with a ui ribbon where user can select the language for the template in a dropdown. The language selection changes all titles and sheetnames accordingly but is there a way to change the labels of the ribbon groups, buttons, etc. as well so that a user...

I've recently started having a problem selecting from drop down menus in the ribbon bar (changing Fill/Font colour etc). When I click on the bottom corner to expand the menu it only half comes up and won't let me select anything (see pic)...

I just added a handful of macro buttons to my ribbon (using Excel for Mac) in customizing my ribbon. On the Windows version of Excel, when you create or rename the button being added to the ribbon, a symbol / icon palette appears, allowing you to choose the icon you want to appear above the...

I have the following XML in a Custom Ribbon I have created <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" ******="RibbonControl******"> <ribbon> <tabs> <tab id="tBreakdowns" label="Breakdowns">...

Hello, Is it possible to hide toolbar, formula bar, ribbon etc.. for only one workbook? link for the workbook : http://s000.tinyupload.com/index.php?file_id=66089730027655191139

Hello all! I have series of add-ins that insert their own buttons into my custom tab on the Excel 2016 ribbon. The code runs from Private Sub Workbook_AddinInstall() in ThisWorkbook of each add-in. No problems there. I've created an add-in manager form where users can select what add-ins they...

Hi After rersetting the ribbon, my workbook is in run mode, and i cannot update the workbook sheets. Is there a way that i can identify and repair the ribbon items that appear to be casuing the loop? I am unclear on how to determine which item(s) are causing the ribbon to stay in run mode...

Hello All, I have been searching for the last hour and I cannot find anything on how to add a slicer to a Ribbon Menu. Is it possible? Kurt

Hi Is there a way to control the format of a Ribbon Editbox. I want to display values all right aligned and to 3 decimal places? My Editboxes are populating OK but the responses are all left aligned and no fixed decimal values Cheers Paul

Hi Is there a simpleway to update my Ribbon Editboxes from cell updates during runtime. I can seesimple ways to populate editbox when opening a Workbook, and updating a cellfrom the Ribbon Editbox during runtime. I cannot see a way to update the ribboneditbox on cell change? All...

Hi, I'm wanting to run macros on files I use often I know an option is to save them all to Personal.xlsb but I would prefer to have them in a ribbon tab, has anyone done this ? Ideally in a drop-down menu ( similar layout to PageLayout > Colors menu)

Hi I made a custom tab on the ribbon. There is a way to get the status of the checkbox ? Can i acces the checkbox by it's name ?

I have a very large, complicated workbook that I created back in the pre-ribbon days that we use every day. Each day, it creates a new worksheet and when the workbook is closed, it renames the sheet based on the date and saves it as a separate workbook. Then, 5 days later, the new workbook is...

Hi I just downloaded office 365..don't know if it's good or bad. The download was free and the yearly fee will be (as long as I stay in good graces with my brother-in-law) :) Is there a way to go back to my old one (Excel 2010)? Some of the ribbon icons changed and I want to see what they...

Hi, I am trying to stop a toggle button from being set as pressed if a column is not selected, How can I do this as the toggle button is on a custom ribbon and not a Form. Can someone help with this please

Hi Is it possible to have a callback for the ribbon when a key is pressed, rather than when they press 'tab' or 'enter' - for a dynamic search? Also, is it possible within VBA to set focus on a Ribbon Control? E.g. after the macro has executed, to go back to the text box in the ribbon? Thanks...