Personal.xlsb

Personal Macros – Personal.xlsb or Add-In.xlam?

Personal Macros, Macros, Ribbon Customization, VBA

My last blog was on accessing personal macros from my custom ribbon. This blog is about where to store these personal macros. These personal macros are the ones that save you time and tedious work. There are basically two ways to go. Some save them to their Personal.xlsb file that loads on opening Excel. Others …

Personal Macros – Personal.xlsb or Add-In.xlam? Read More »

My Custom Ribbon using Formulas to Create XML code

Formulas, Ribbon Customization, Uncategorized

Update 11/08/21 I received an email from Clem who has written an awesome Add-In called Ribbon Icons which looks like below, to address the painful process I whinge about below for choosing and adding icons to your custom ribbon. I just can’t believe someone has nailed the solution to this horrible process a) you can …

My Custom Ribbon using Formulas to Create XML code Read More »