This video and the corresponding blog post below is in response to a question I have been asked recently. A subscriber could not find or locate any Macros they had stored in their Personal Macro Workbook. Where had ALL that work gone?. Where were the missing macros?. They were freaking out. (Of Course!). Their Personal Macro Workbook was missing.
The Personal Macro Workbook was not showing up in the VB Editor. So, time to troubleshoot. So, they informed me that Excel had crashed recently so that probably had something to do with it right?. Right. The macros were probably disabled when this happened. So, here is the solution I shared with them to get their Personal Macro Workbook and all of those precious Excel macros back up and running again.
Here are the solution and the blog post that goes with this Excel Tip video
https://howtoexcelatexcel.com/vba/enable-your-personal-macro-workbook-help-where-did-it-go/
Join me EVERY FRIDAY for #formulafriday and EVERY MONDAY for #macromondays on the http://www.howtoexcelatexcel.com blog for lots of #exceltips
Join thousands of other Excel users who have already joined the Excel At Excel Monthly Newsletter. 3 FREE Excel Tips every month. Plus FREE 30 Tips EBook.
http://www.howtoexcelatexcel.com/newsletter-sign-up/
Be Social & Let’s Connect
++Website http://www.howtoexcelatexcel.com
++Twitter https://twitter.com/howtoexcelatex
Keep Excelling!.