How to solve the problem which causes the Excel error message "Personal
Personal Macro Workbook Must Stay Open. Web go to developer > visual basic to launch the visual basic editor (vbe), which is where your macros are stored. Go to the developer tab in the ribbon.
How to solve the problem which causes the Excel error message "Personal
Here are the steps to create a personal macro workbook in excel: 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 need to first create it. You will see your module there. If you don't see it, go to view > project explorer. Web go to developer > visual basic to launch the visual basic editor (vbe), which is where your macros are stored. Then click on the module and drag it into the personal folder. Then if you close that workbook, recorded macro. 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. Web by default, the personal macro workbook doesn’t exist.
Web by default, the personal macro workbook should not be visible in excel. Then click on the module and drag it into the personal folder. Open a new workbook or any existing workbook. It opened up the file that has the personal.xlsb attached. If the personal.xlsb file keeps opening whenever you use macros and this really bugs you, you can hide it in this way: Then if you close that workbook, recorded macro. 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 you don't see it, go to view > project explorer. You can find your personal macro workbook in the project explorer pane on the left hand side. 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.
