Macro Mondays – How To Remove All Hyperlinks From An Excel Workbook
Hello, Excellers. Welcome back t another #MacroMonday Excel blog post in my 2020 macro Series. I recently had this question submitted via email from a subscriber. How to remove all hyperlinks. ...
Macro Mondays – What are the Three Windows In The Visual Basic Editor For?
Hello, Excellers. Are you new to Excel Visual Basic?. Just need a refresher?. Well, it is back to basics of the good old macro today. Let's take a look at what the three different Visual Basic...
Macro Mondays – 3 Reasons To Use Comments In Your Excel VBA Code
Hello, Excellers it is time for another blog post on #MacroMonday series again. Today I will go through my top 3 reasons to use comments in your Excel VBA Code. This is sometimes also...
Hello Excellers and welcome back to another #MacroMonday #Excel blog post in my 2020 Excel Macro series. DO you ever have a lot of workbooks open at once?. It takes a long time to close all of...
Hello Excellers and welcome back to another #MacroMonday #Excel blog post in my Excel 2020 series. Today I will show you how to write some Excel VBA code that will hide all of your Excel worksheets...
Hello Excellers and welcome back to another #McaroMonday #Excel blog posit in my Excel Macro 2020 series. Today I will show you how to write some code that will allow you to check if an Excel folder...