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...]
Hide All Excel Worksheets Except The Active One.
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 except the active one in your Excel workbook. This will save you a lot of time hiding individual worksheets one at a time. Let's get coding!. 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 … [Read more...]
- 1
- 2
- 3
- …
- 33
- Next Page »
Recommended Excel Resources
