Macro Monday – How To Automatically Lock A Cell After A Value Is Entered
Welcome to another #macromonday blog post in this series. This blog post is in answer to a question sent to me by a subscriber. They wanted to know how to lock a cell once there was a value...
Excel Macro Monday – Watch Excel Record Your Macro In Real Time
Hello Excellers and welcome to another blog post in my #macromonday series. This is the place where we discuss all things Excel macro and Excel VBA. Today I want to share with you real-time VBA...
Macro Mondays -Creating and Updating Your Personal Macro Workbook
Hello Excellers, welcome to another #macromonday blog in this series. Today let's look at saving macros to a personal macro workbook to reuse in any workbook when you start Excel on your...
Hello Excellers. Welcome back to another #MacroMonday blog post. Today let's look at how to create a simple Excel VBA Macro which will be useful for converting your data to uppercase on your...
Remove All Data Connections From An Excel Workbook Using VBA – Excel Macro
Hello, Excellers, welcome back to another #macromonday blog in this series. Glad to have you back. Today let's look at removing all data connections from an Excel workbook. Why would you want...
How To Write A Macro To List All Files In A Folder – Macro Mondays
Hello, Excellers I am excited to share with you some cool VBA Macro fun. I find this a really useful macro which uses the Excel For Loop to list all files in a folder or directory. Similarly, we...