1. M

    Ribbon changing appearance when pinned/unpinned

    Hi All, this is driving me crazy... When I have my ribbons unpinned (aka show tabs) they appear like this - as they have always been, but as long as i move the cursor away they disappear Although, if I pin them (aka activate the show tabs and commands option) they are shown as below, occupying...
  2. Fida_mutia

    Disable and enable one of excel functions in ribbon menu.

    Hey, I wanna know how to disable one of excel functions in the ribbon menu? And how to enable it again? For example, I want to disable the pivot table function so that I can't create pivot table in my worksheet. Also I want to know how to enable the pivot table function again. That's all my...
  3. M

    How to create a macro add-in with customized ribbon?

    Please Help! Hello, I have a VBA module with 50 + macros located inside of personal.xlsb. I have customized an elaborate ribbon that links to all of these macros. I am trying to port this setup into a new workstation. I just made a copy of the personal.xlsb and put it in the xlstart folder...
  4. M

    How to transport Customized Ribbon Linked to Macros to another system

    Hello, I have a VBA module with 50 + macros located inside of personal.xlsb. I have customized an elaborate ribbon that links to all of these macros. I am trying to port this setup into a new workstation. I just made a copy of the personal.xlsb and put it in the xlstart folder of the new...
  5. F

    Load Exported.UI file on Work book start up

    How would I go about Loading the Exported.UI file when loading the workbook and Reset it upon closing I have a workbook that I have customized the Ribbon using the "customize ribbon" option within Excel. I want the particular Ribbon customizations only for that workbook. thanks
  6. B

    Hide tabs and ribbon in Excel with VBA

    Hi I wonder how to autohide the ribbon and tabs with VBA Bengt
  7. B

    Toggle Zoom and Minimize and Maximize Ribbon

    I am attempting in the code below so when I run the macro it will zoom to 50 and minimize then when I run the macro again it will zoom to 90 and maximize. Please help me get the code correct. Thanks as always Sub ribb_zoom() CommandBars.ExecuteMso "MinimizeRibbon" ActiveWindow.zoom =...
  8. countryfan_nt

    VBA to hide ribbon, done, but now vaidation deactivated

    Hello friends, Hope all is well! thanks to you, I succeeded in hiding the ribbon by using the below line. problem now: validation dropdown menu is not active. if I remove the below line the validation works. please help me remove the ribbon and allow the validation's dropdown menus to work...
  9. A

    Looking to make custom Ribbon buttons

    Any really for idiots guide to making custom Ribbon buttons? I'd like one that toggles between "Center Across Selection" on and off. Another that toggles through Plain, Underline, Single Accounting Underline to ideally replace the underline button. Is this possible? I downloaded the...
  10. M

    Customised Ribbon using Custom UI editor for Microsoft Office

    Hi. I have created a new ribbon using the editor and have created about 60 new tabs. Well as you imagine having all these tabs are a bit of nightmare scrolling along to find the tab i want. Does anyone know if there is a way of using a macro to search for a particular tab, maybe a combobox...
  11. I

    DIY VBA Excel Ribbon Editor

    Hello! In short: I would like to create Excel Ribbon Editor for Windows using VBA. Doeas it make sense? :) I found two types of excel ribbon editors: Editors such as Office RibbonX Editor (famous Ron de Bruin site). This editor just help user to change add own xml ribbon file to excel file...
  12. B

    Custom IRibbonUI loads inconsistently only on Mac

    Hello there, I have an extensive custom excel add-in which engages in all sorts of macros when opening certain files (tests are done on workbook open before performing any of the macros) and the add-in includes a custom ribbon. Until recently this add-in has only been used on windows, but I've...
  13. D


    Can anyone suggest a good source for icons? I'm wanting to add some macros to the a tab as a customization to the Excel ribbon. Thanks.
  14. K

    Lock Ribbon

    Does anyone know if there is code to lock the ribbon so that none of the tabs can be selected? Or even hidden and locked?
  15. VBE313

    Ribbon EditBox to add text instead of number

    I have a macro that I used to input numbers in cells/textboxes in my sheet. however, i am puzzled as to how i would declare my variable instead of "As Double" How can I add text rather than an integer? Public Sub ToQuote_Change(control As IRibbonControl, text As String) 'Changes the To: in...
  16. danhendo888

    Why do I see green ribbon on top left corner of a cell

    When I paste data onto a spreadsheet. For columns formatted as General which has numbers in it, it says Number stored as Text with an option to Convert to numbers. Why do I see this despite the formatting being general? Even when I highlight the entire column and format the column cells to...
  17. B

    Adding Analysis Toolpak and Solver To a Custom Ribbon Tab

    I have created a custom tab on my ribbon through File > Options > Customize Ribbon and I have populated it most of the way with the Add button. I have added Solver and the Analysis Toolpak (Data Analysis button) addins to Excel and by default, Excel places them at the end of the Data tab on the...
  18. M

    Want to hide the ribbon on every opened excel file - VBA

    My code below opens an excel file using a user form. My code for some reason hides the ribbon every OTHER time it opens an excel file rather than every consecutive time. Am I missing something? Is there a way to narrow down the hide ribbon to the new opened workbook and active sheet? Private...
  19. S

    Run addin through customized ribbon

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

    How Do I Get My Addins Ribbon Button To Display?

    I installed the MrExcel HTML Maker addin. I shows as installed in the OPTIONS>ADDINS dialogue, and it the manage addins dialogue it is checked. But how do I access it? I have no Addin's Button in my ribbon or the menu, although in the OPTIONS>CUSTOMIZE ribbon settings, "Addins" is checked. I...

Some videos you may like

This Week's Hot Topics