Add your personal Excel Macros to the ribbon
If you find yourself using the same macros over and over again, you can create a personal *.xlsb file that opens every time you start excel. You need excel 2010 or a later version for this tutorial.
Create a personal *.xlsb file
- Create a new workbook (CTRL + n)
- Go to VB Editor (Alt + F11)
- Insert a module
- Copy macros to module
- Exit VB Editor and return to excel
-
Save workbook as a *.xlsb file to this folder:
C:\Users\<username>\AppData\Roaming\Microsoft\Excel\XLSTART - Exit excel
- Start excel
- Your personal.xlsb file opens automatically
- Go to tab "View" on the ribbon
-
Click "Hide" button
- Exit excel
The next time you start excel, a new workbook is created. The personal.xlsb opens but is hidden.
Recommended macro for your ribbon
Remove print preview lines (Page Breaks)
Have you ever wondered how these lines got there on a worksheet? They show where pages will break, in other [โฆ]
Remove print preview lines (Page Breaks)
Link macro to excel 2010 ribbon
Excel 2010 allows you to customize the ribbon and link your personal macros to a button each. So you can quickly and easily access your favorite macros.
- Go to "File" on the ribbon
- Click "Options"
- Click "Customize Ribbon"
-
Click "New tab"
- Rename new tab
- Select macros from drop down list
- Select a macro
- Click "Add"
- Click "Rename"
- Pick an icon and type a name
- Click OK
Recommended macro for your ribbon
Highlight row and column of selected cell
Today I would like to share with you these small event handler procedures that make it easier for you to [โฆ]
Highlight row and column of selected cell
Example macros to save in your personal.xlsb file
- Remove print preview lines (Page Breaks)
- Create links to all sheets in a workbook
- Insert hyperlinks to all files in current folder
- Follow hyperlinks in a pivot table
- Select cell A1 on all sheets before you close a workbook
- List files in a folder and subfolders
Read more
This article demonstrates a macro that copies values between sheets. I am using the invoice template workbook. This macro copies [โฆ]
Open Excel files in a folder [VBA]
This tutorial shows you how to list excel files in a specific folder and create adjacent checkboxes, using VBA. The [โฆ]
Split data across multiple sheets [VBA]
In this post I am going to show how to create a new sheet for each airplane using vba. The [โฆ]
Identify missing numbers in a column
The image above shows an array formula in cell D6 that extracts missing numbers i cell range B3:B7, the lower [โฆ]
Working with COMBO BOXES [Form Controls]
This blog post demonstrates how to create, populate and change comboboxes (form control) programmatically. Form controls are not as flexible [โฆ]
Change chart data range using a Drop Down List [VBA]
In this article I will demonstrate how to quickly change chart data range utilizing a combobox (drop-down list). The above [โฆ]
This workbook contains two worksheets, one worksheet shows a calendar and the other worksheet is used to store events. The [โฆ]
Run a Macro from a Drop Down list [VBA]
This article demonstrates how to execute a VBA macro using a Drop Down list. The Drop Down list contains two [โฆ]
How to create an interactive Excel chart [VBA]
This article describes how to create an interactive chart, the user may click on a button or multiple buttons and [โฆ]
What's on this page Copy a file Copy and rename a file Rename a file List files in a folder [โฆ]
4 Responses to โAdd your personal Excel Macros to the ribbonโ
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
English
Spanish
Iโve got my two macroโs placed up on my ribbon, each with a nice icon, and each calls up a user form. When it work, it works great. Then, mysteriously, it started disabling itself whenever I selected a different workbook, and then switched back. Message appears that the macroโs arenโt enabled, or some such. After lots of frustration, I randomly discover that if I called up one of the macros manually, within the Developer/Macros/ option, the two ribbon icons were now functional again. They work dependably until I leave the workbook and return again. Any idea of a permanent fix for this? Thanks so much,
Steve
Interesting theory
Doesn't work
Put the file WHERE?!
How can I save it and send to other people?
Thuan Ha,
It seems that you can't create a custom ribbon programmatically:
https://stackoverflow.com/questions/8850836/how-to-add-a-custom-ribbon-tab-using-vba
https://www.excelfox.com/forum/showthread.php/105-Add-ribbon-programmatically-to-Excel-2010-using-VBA