It's Monday so must be time for some #MacroMonday Excel fun. Today I want to share with you a really handy Macro that will save a backup copy of your workbook with today's (or whatever date it is) date. How cool is that?. I use this a LOT. Making backups of your Excel file should be part of your usual spreadsheet routine. What Does The Macro Do? This Macro will save your Excel workbook to a new file with today's date as part of the filename. I love this, as I can find easily … [Read more...]
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. They had a LOT of hyperlinks in an Excel workbook (with 50+ sheets). They needed to quickly delete the hyperlinks as they were no longer relevant. It is easy to remove multiple hyperlinks from a single worksheet, but removing hyperlinks from multiple worksheet tabs requires a little more work. … [Read more...]
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 windows are for in the Developer Tab The Three Visual Basic Windows. The Project WindowThe Code WindowThe Properties Window The Developer Tab needs to be enabled in order for you to see this window. So, if you cannot see the Developer Tab, don't worry it is really easy to enable it. Feel … [Read more...]
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 referred to commenting out a block of code. Top 3 Reason To Use Comments In Your Excel VBA Code. So, let's look at my top 3 reasons to use comments or commentary in your Excel VBA code. When looking at Excel VBA code you may have noticed that some of the code is (usually) in green. … [Read more...]
How To Close All Excel Workbooks At Once.
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 those Excel workbooks, doesn't it?. So, today I will show you how to close all Excel workbooks at once with a simple Excel VBA Macro. Starting The VBA Macro. First, you will need to open the Visual Basic Editor. There are two ways to do this. Either by hitting ALT +F11 orSelecting the … [Read more...]
- 1
- 2
- 3
- …
- 33
- Next Page »
Recommended Excel Resources
