ribbon

  1. J

    Excel - get the idMso for the texture fill offset of the plotarea of a chart

    Hello, I would need the idMso to these functionalities : I would like to add them to my custom ribbon Thx in front
  2. E

    Refreshing the ribbon interface before a call from a macro

    When creating custom ribbons, at some points in the application I need to be able to enable and or disable the button commands. Here is the specific portion of the ribbon script: <customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" onLoad="OnMainLoad"> <ribbon...
  3. Y

    Placing Macros on the ribbon

    I have an Excel macro that performs a few functions, it takes a excel table from worksheet, creates an array of it contents, performs a mail merge in word, Creates a form, and a few emails(from MS-Word documents). If the macro is executed from the main spreadsheet, where the macro is, everything...
  4. golden_cowrie

    How my Excel looks has changed, can I change it back

    My Excel page used to look like the second photo, but now it looks like the first one, can I change it back?
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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
  10. B

    Hide tabs and ribbon in Excel with VBA

    Hi I wonder how to autohide the ribbon and tabs with VBA Bengt
  11. 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 =...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. D

    Icons

    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.
  18. 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?
  19. 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...
  20. 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top