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...]
How To Save Excel Worksheets As Separate PDF Files.
Hello Excellers and welcome to another #Excel #MacroMonday blog post in my 2021 series. I want to show you how to export and save all of your Excel worksheets in an Excel workbook as separate PDF files. This is particularly useful if you have as in my example multiple sales regions and you need to save the worksheets for each region in their own file. In my example, I have four sales regions. I need to save each region's report separately and send it as a PDF file to the regional … [Read more...]
Macro Mondays – Running An Excel Macro From The Immediate Window
Hello, Excellers welcome to another #MacroMonday #Excel blog post in my 2021 Excel Macro series. Today let's take a look at using the Immediate Window in the Excel VBA debugging environment. This environment can be used as a type of scratchpad or sandbox area and has many uses as well as debugging code. You will need to first Enable The Developer Tab if it is not already enabled. You can watch my YouTube Video for instructions. https://youtu.be/CYcyoBMTZ44 If you … [Read more...]
Macro Mondays – How To Assign An Excel Macro To A Button Or Assign A Button To An Excel Macro
Hello, Excellers Welcome back to another #Excel blog post in my #MacroMonday 2021 series. I want to show you how to assign an Excel Macro to a button or assign a button to an Excel Macro, whichever way you want to say it!. There are a few ways to run an Excel Macro that you have created. A brief summary of which can be seen below. Run the Macro from the Immediate Window in the Visual Basic screen. (you can read more about Running An Excel Macro From The Immediate WindowYou can … [Read more...]
- 1
- 2
- 3
- …
- 34
- Next Page »
Recommended Excel Resources
