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 set up in a tab and would just click the macro for the job I was running and it would format my document accordingly. As everyone knows, this saves a significant amount of time. Why this happened, I don't know. The only option now is to rebuild them.
This is the process I'm doing to rebuild them:
- Developer tab
- Record Macro
- In Record Macro Box
- Name Macro
- Store macro in: Personal Macro Workbook
- Click: OK
- In Record Macro Box
- Record Macro
- Error Message Returned: "Personal Macro Workbook in the startup folder must stay open for recording."
I don't know how to get this Personal Macro Workbook to open. I thought that this workbook would automatically open at the start up of Excel.
This glitch has caused me so much time and energy that it has actually put me behind in my work.
I've checked the path and the "Personal.xlsb" file is in the XLSTART folder.
6 Replies
Not even if you click that little plus next to VBProject (Personal.xlsb) in the Project explorer pane? Also expand the Modules node if it's there.
I swear, sometimes it's the simplest/smallest things! Thank you!
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!
My problem is that when I reopen Excel on step 8 the newly created PERSONAL.XLSB file is not openned. Excel keeps igniring it even it is exist in the startup folder. How I can fix that?
