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...
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. ...
A VBA Excel Macro Which Will Export And Save Each Worksheet As A Separate PDF – Macro Mondays
Hello Excellers and welcome back to my regular blog spot of #macromonday. Today, I want to show you how to write a simple Excel VBA macro which will convert to PDF then export and save each of...
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...