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...]
Macro Mondays – Convert A Range Of Cells To Lower Case With An Excel Macro
Hello, Excellers. Time for some more #Macro fun. So, you may (or may not) know that you can change the case of text to a lower case using the Excel LOWER function Excel. Alternatively, a small bit of Excel VBA code will do the same over and over again automatically. Let's get writing some simple VBA. If you want more Excel and VBA tips then sign up to my monthly Newsletter where I share 3 Excel Tips on the first Wednesday of the month and receive my free Ebook, 30 Excel … [Read more...]
Automate A Table Of Contents In Excel
Hello, Excellers. Welcome back to another #MacroMonday #Excel blog post in my 2021 Excel series. I love this macro. I really do. It is great to have it to hand when needed. This small bit of code will automate the creation of a table of contents in your Excel workbook. Yes, that is right. In short, run this code and Excel inserts a new worksheet with links to all of the sheet tabs with a hyperlink automatically. So, that is a good bit of time-saving right?. Prepare To Write The … [Read more...]
Create A Yes No Message Box Before Running An Excel Macro.
Welcome back to another blog post in my #ExcelTips #MacroMonday Excel 2021 series. There a few ways to run an Excel macro. Hit the F5 key or the Run button while in the VBA window. But, sometimes a giving the user a warning before the macro is run, or ask if they are sure they want to run it the macro is a good safety net. The Yes No message box is a really good way to do this. The logic is simple. Hit Yes and the code or macro runs. Hit No, the code stops running. You are asking are you … [Read more...]
Convert All Formulas Into Values Excel Macro.
Hello Excellers and welcome back to another #MacroMonday blog post in my #Excel 2020 Excel tips series. Today we will write an Excel macro that will very quickly convert all of your formulas into values. Yes, that is correct, this macro will convert all Excel formulas into absolute values with one click of the mouse. Prepare To Write The Macro. First, open the Visual Basic Editor. There are two ways to do this. Hit ALT +F11 orSelect the Developer Tab | Code … [Read more...]
- 1
- 2
- 3
- …
- 36
- Next Page »
Recommended Excel Resources
