A while ago I wrote a blog post about creating and updating your Personal Macro Workbook, so if you want to learn more about creating the workbook, you can read that using the link below.
Today I want to talk today about why your Personal Macro Workbook may not be automatically loading in Excel. I had this problem recently, all was going well, every time I opened Excel my trusty Personal Macro Workbook loaded up too, until one day it did not.
After some digging around, it seems there are a few reasons, and I want to share them with so you don’t have to manually navigate to the file and manually opened it, like I did for a day or so. So let’s work through the check list of possible problems, and how to fix them.
1. Read Only?
The first thing I checked was, is the file set to READ ONLY?. Load up the Personal.xlsb file and look in the title bar to see if it says READ ONLY, remove the read only attribute and try again by starting Excel.
This may solve your problem and you will know once you have re opened Excel, move onto the next issue if not.
2. Has The Workbook Been Disabled?
Excel may disable the Personal Macro Workbook if it thinks it it will not work with Excel or it has become corrupted in some way. In excel 2016 follow the steps below to see if it has become disabled.
- File – Options – Add Ins
- In the Manage area at the bottom of the screen select Disabled Items Ins and hit Go
- If you file appears here then you can simply enable it again
This is only a temporary fix, as Excel has for some reason disabled it. It probably is corrupted on some way. I suggest you create a new one, or restore from a back up if you want to keep all of your macros stored in your Personal Macro Workbook
3. Have You Trust Issues?
it may also be that Excel does not trust the directory that holds the Personal Macro Workbook. it is meant to be a directly that is a trusted one but if not trusted Excel will not load anything contained in it. This again is easy to check.
- File – Options – Trust Centre
- Open the Trust Centre Settings
- Check that your directory containing your Personal Macro Workbook is located as a trusted location – if nt you need to add it into this area.
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. If you want to see all of the blog posts in the Macro Mondays Series you can do so by clicking on the link below.