ribbon

I've created a workbook with several coded macros of which I've assigned to buttons in a custom Ribbon tab for the workbook. When I am coding new macros or changing code, I make a copy of the workbook and do it in the new copy so as to not corrupt the current version in case I make a mistake...

Hi, I recently started a project in which I am creating a custom excel ribbon for myself. One of my tools has to do with a dropdown button within the ribbon. The dropdown is working fine but I would love excel to remember the ID the dropdown was on when excel is closed and put it on the same ID...

Hello! I have gotten so much help from this board and I do not feel the greatest where my first contribution is in the form of another question/problem, but now that I am here, who know!? I will try and keep it short. I have built an Excel-based scheduling tool with a custom ribbon in a shared...

I had a problem that starting Excel from Python whacks the Custom ribbon. I eventually got code that does the job. Starting Excel from Python does not whack the Custom ribbon anymore. With complements of losing the state of the global IRibbonUI ribbon object This was written some years ago and...

I have a custom ribbon in Excel with macros assigned to it. One set of macros does just sheet/column formatting, sort data etc. Normal Excel stuff. Those all works. Then I have two specific macros that removes the custom ribbon completely when they execute. Well, after the executed the Custom...

Hi I would be really grateful if someone could give me either high-level or detail steps on achieving the following: --- I want to create a file (which I am thinking will be an add-in), that my colleagues can import into their Excel, and when they do, they get a custom ribbon which has the...

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

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

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

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

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

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

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

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

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

My Excel page used to look like the second photo, but now it looks like the first one, can I change it back?

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

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

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

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