ribbon

  1. D

    Adding macro to ribbon without opening Excel

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

    Vba activate screenshot drop-down.

    Hello all, Currently I have and excel coversheer made and the ribbon and other parts are completely hidden to make a clean experience. Hidden by Application.ExecuteExcel4Macro "show.tpolbar(""Ribbon"",False). What I am looking for is a way to utilize a function in the ribbon while it's...
  3. K

    Custom Ribbon onload Questions

    I am building a ribbon which can shows a custom tab in a certain workbook. This is the sample code on the ribbon: <customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" onLoad="onLoad"> <ribbon> <tabs> <tab id="MyTab" label="Custom"> Bunch of stuff here...
  4. Rijnsent

    Excel - custom menu bar UI freezing & crashing file

    I have a big excel file (20 modules, 40 sheets, 5 forms) with a custom menu bar. The main issue I have: after I've run certain macros (got dozens doing various stuff), whenever I switch worksheets, my Excel will freeze, crash and re-open my file. The custom menu bar has several bits that are...
  5. L

    Workbook_open() not working because of timing

    Dear all, I write some code to expand ribbon when open workbook (in ThisWorkbook): Private Sub Workbook_open() If Application.CommandBars("Ribbon").Height<=100 Then SendKeys "^{F1}", True End If End Sub But it not working. I think because of loading time when file opened. Could someone has...
  6. J

    Adding custom tab to the ribbon to call userform

    Hi all, I have a workbook that contains a userform used by members of a team. They complete the userform, click submit, and this collates their data into a "Master" workbook that I use. All works - no issues. Due to the nature of the userform - it's mainly for recording ideas as they're...
  7. 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
  8. 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...
  9. 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...
  10. 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?
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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
  16. B

    Hide tabs and ribbon in Excel with VBA

    Hi I wonder how to autohide the ribbon and tabs with VBA Bengt
  17. 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 =...
  18. 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...
  19. 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...
  20. 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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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