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 … [Read more...]
Macro Mondays – How To Add A Break Point To Your Excel VBA Code
Hello, Excellers. Welcome to another #macroMonday blog post in my Excel tips 2021 series. Today let's look at breaking up our VBA code by adding a breakpoint to your Excel VBA code. This pauses the code at a point we choose to enable us to use the debugging environment, to perform checks to ensure all is running as expected with our Macro. First Things First - What Is A Breakpoint? A breakpoint is a selected line of code that once it has been reached, your macro will be suspended. … [Read more...]
Macro Mondays – How To Protect Your Excel VBA Code
Hello, Excellers. Welcome back to another #MacroMonday Excel tips blog post in my #Excel 2021 series. This blog post will show you how password protect your Excel VBA code. As well as being able to protect your Excel formulas, it is prudent to also protect your VBA code. It is also very simple. Open Visual Basic – by hitting ALT +F11 or Developer Tab – Visual BasicSelect your project from the list of projects if there is more than one Right-click on your project you want to … [Read more...]
Macro Mondays – Convert A Range Of Cells To Upper Case With An Excel Macro
Hello, Excellers. Welcome back to another #MacroMonday blog post in my #ExcelTips series for 2021. You may or may not already know how to convert all text to upper case in Excel by using the UPPER function. It works. But, it takes a bit longer than this little Excel Macro I am going to show you today because yes it is indeed VBA code time. So, if you want more Excel and VBA tips then sign up for my monthly newsletter where I share 3 Excel Tips on the first Wednesday of the month and … [Read more...]
Remove Hyperlinks From An Excel Workbook
In this blog post, I will show you how to easily remove multiple hyperlinks from an Excel workbook. I recently had this question submitted via email from a subscriber. They had a LOT of hyperlinks in an Excel workbook (with 50+ sheets), and they wanted to quickly remove all of 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. Let's work through … [Read more...]
- 1
- 2
- 3
- …
- 37
- Next Page »
Recommended Excel Resources
