How to solve the problem which causes the Excel error message "Personal
Personal Macro Workbook Must Stay Open. So i'm currently resorting to storing recorded macros ion the current workbook instead, which is inconvenient. Web try the following steps to fix this personal macro workbook fails to load issue:
How to solve the problem which causes the Excel error message "Personal
Then double click to open it, and if you have been storing all your vba code in the personal workbook then it will be in the workbook. Web by default, the personal macro workbook should not be visible in excel. Web by default, the personal macro workbook doesn’t exist. Web try the following steps to fix this personal macro workbook fails to load issue: If you don't see it, go to view > project explorer. Web i get the error message personal macro workbook in the startup folder must stay open for recording when i want to record a macro to my personal macro workbook so i can run the macro on any worksheet. You will see your module there. Web 'personal macro workbook in the startup folder must stay open for recording'. You can then remove the module from the active workbook. Web personal macro workbook in the startup folder must stay open for recording. click ok unable to record. found personal.xlsb in c:\users\xxxxx\appdata\roaming\microsoft\excel\xlstart i opened up personal.xlsb file.
So i'm currently resorting to storing recorded macros ion the current workbook instead, which is inconvenient. You will see your module there. You can follow the question or vote as helpful, but you cannot reply to this thread. Then click on the module and drag it into the personal folder. Web i get the error message personal macro workbook in the startup folder must stay open for recording when i want to record a macro to my personal macro workbook so i can run the macro on any worksheet. If the personal.xlsb file keeps opening whenever you use macros and this really bugs you, you can hide it in this way: Open a new workbook or any existing workbook. In the record macro dialog box, specify a name (default is fine too). Go to the developer tab in the ribbon. Web go to developer > visual basic to launch the visual basic editor (vbe), which is where your macros are stored. Web create the macro in a standard workbook and then look in the vba project window.
