Hi Excellers, and welcome back to another #Excel #MacroMonday blog post in my 2019 series. Today I want to show you how to write a quick and straightforward Excel VBA macro to highlight all named ranges in Excel. This macro is handy if you are not sure if you have named ranges in your Excel workbook or how many. In addition, it is advantageous if you have inherited an Excel workbook and must work out its structure to understand it quickly. Tutorial Contents.Preparing To Write The Code To … [Read more...]
Macro Monday – Why Is My Personal Macro Workbook Not Loading Automatically?
Today's blog post is an answer to a common question I receive. Why is my Personal Macro Workbook not loading automatically in Excel?. I had this problem recently also. All was going well. Every time I opened Excel, my trusty Personal Macro Workbook loaded up too, until one day it did not. A while ago, I wrote a blog post about creating and updating your Personal Macro Workbook. If you want to learn more about the workbook, you can read that using the link below. Macro Mondays -Creating … [Read more...]
Macro Mondays – Renaming An Excel Macro.
Hello, Excellers. Welcome to #MacroMonday again. Today let's take a look at renaming an Excel Macro. For some reason, you may find yourself having to rename one of your Excel Macros that you have already created. It is quick and easy to do. So, let's take a walkthrough. 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 Tips. How To Excel At Excel – Macro … [Read more...]
Macro Mondays – Create A Macro To Schedule An Automatic Backup Of An Excel File When You Close It.
It is time again for some more #macromonday fun. Today I want to share with you a really useful Macro that will schedule an automatic backup at whatever time you choose of your Excel file. If you have ever lost any Excel files or data then you know how useful this small piece of VBA code will be. 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 receive my free Ebook, 30 Excel Tips. To … [Read more...]
Macro Mondays – How To Assign Or Change A Macro Shortcut Key
Hello Excellers, time for some back to basics today with Excel Macros. Let's take a look at assigning or changing a shortcut key with a Macro. Yes, welcome back to another #MacroMonday blog post in my Excel 2021 series. The Basics Of Excel Macro Shortcut Key. When you start recording a macro with the Macro Recorder, the Dialog Box appears. This has a section or space for a Shortcut Key to be assigned to the Macro. this means it can be run quickly with the keyboard shortcut. See … [Read more...]
- 1
- 2
- 3
- …
- 33
- Next Page »
Recommended Excel Resources
