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...
An Excel Macro That Will Copy An Entire Worksheet To Another Workbook – Macro Mondays
Hi Excellers, welcome back to another instalment of #macromonday. Let's look at how to save a tonne of time by writing a simple Excel VBA Macro that will copy an entire worksheet from one Excel...
An Excel VBA Macro To Convert All Formulas To Values – Macro Mondays
Hi, Excellers welcome to another blog post in the #macromondays series. Today, let' s look at saving a tonne of time. Sounds good right?. We will write an Excel VBA macro which will convert all...
Highlight Misspelled Words In Excel With A Simple VBA Macro – Macro Mondays
Hello and welcome to your weekly instalment of #macromonday. A great way to learn how to write Excel VBA macros. Today we will let's look at mistakes, or being more specific misspelled words. ...
Display An Pop Up Message To Users Opening An Excel File – Macro Monday
Welcome, Excellers and time for another #macromonday. Today I want to share with you how to display we welcome (or any other message) on your Excel workbook when it is opened. I use this small...