Forum Discussion
Issue with saving Macros Personal Macro Workbook in the startup folder must stay open for recording
Hi, I'm hoping one of the Excel gurus can assist me with this issue I am suddenly having with Macros. Suddenly all of the macros I had saved and have been using have dissappeared. I had these Macros...
Looks like your personal macro workbook has a corruption of some sort. Here are some steps to fix it:
- Close all Excel instances
- Check Task manager, details tab to see if there is no Excel.exe
- If there is, end its task
- Move the existing personal.xlsb from the XLSTART folder to somewhere else
- Rename the moved file to something like personal_old.xlsb
- Open Excel and record a macro to your personal macro workbook
- Close Excel and choose to save the personal macro workbook
- Open Excel again and open personal_old.xlsb
- Open the VBA editor and copy all modules (you can drag them) from your personal_old.xlsm to your new personal.xlsb
- Close Excel and save your Personal macro workbook
JKPieterse​ if you still happen to monitor... I got stuck at step 8/9, I don't see any modules to drag? Been trying to fix this for weeks, no idea what happened, I used to record Macros no problem, and one day it stopped working. Any help/feedback is welcome!