Category: Personal Macros

This is another handy personal macro I use in my day to day spreadsheeting and application building.  It sits in my Add-In which has it’s own tab on my custom ribbon, but you might just use the ribbon QAT or …

Personal Macros – Locked & Unlocked cells Read More »

Tagged with: ,

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 …

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

Tagged with: ,

I thought I would blog some handy personal macros I use day to day.  This is the first and I will do others. This one simply needs to select all formulas (so I called it SelectAllFormulas) the worksheet using the …

Personal Macros – SelectAllFormulas Read More »

Tagged with: , , , , , , ,