Macro Mondays – Unlock ALL Cells In An Excel Workbook With VBA
Macro Monday time and that means some more Excel macros and VBA. Today let's look at a tiny Macro that pulls a punch. Are you a Microsoft Excel user who stares in frustration at your workbook,...
Are you regularly transferring files from one folder to another? Things can quickly become tedious and time-consuming - but not anymore! Excel VBA Macros enable an easy yet efficient way of copying...
Macro Mondays – How To Add A Break Point To Your Excel VBA Code
Hello, Excellers. Welcome to another #MacroMonday blog post in my Excel series. Today let's look at breaking up our VBA code by adding a breakpoint to your Excel VBA code. If you're an Excel...
Macro Mondays – Automatically Protect A Worksheet When You Close Your Excel Workbook
Hello Excellers, it is time for some more cool code in the #macromondays series. It can be a pain to remember to protect your worksheets every time you close your Excel workbook. But with a few...
Macro Mondays – Delete All Rows That Contain A Specific Text String
Hello Excellers, time for some Excel Macro fun again. Today's Excel Macro tip is one I have been looking forward to sharing with you for a while. Are you looking for a quick way to delete all...
Macro Mondays – How To Write A Macro To Delete Rows If A Cell Is Blank
Hello Excellers. If you're an Excel user, you know that one of the most tedious tasks is deleting rows if a cell is blank. Well, worry no more! With a simple macro, you can delete any number of...