Personal Macro Workbook In The Startup Folder Must Stay Open For Recording. Excel 2016 Mac

Personal Macro Workbook In The Startup Folder Must Stay Open For Recording. Excel 2016 Mac 8,5/10 4805 votes

Hi All, If I do alt-TMR in excel to record a macro, and opt to store the macro in personal.xls, I get a nice 'microsoft excel' OKonly popup telling me 'personal macro workbook in the startup folder must stay open for recording'. Taking the only choice available (OKonly) gives me another OKonly popup telling me 'Unable to record'. So I'm currently resorting to storing recorded macros ion the current workbook instead, which is inconvenient.

If anyone else has seen this message before and know why it appears and, more important, how to get personal.xls working normally, then please respond.

Personal Macro Workbook In The Startup Folder Must Stay Open For Recording. Excel 2016 Mac

If you receive the error 'Personal macro workbook in the startup folder must stay open for recording' when trying to record a new Excel Macro, or if all of your previously-saved macros have disappeared, you can often recover the macros by taking the following steps: Click on 'Help' Click on 'About Microsoft Excel' Click the 'Disabled Items.' Button Select the item in the list that says 'Personal.XLS' and click 'Enable' If there is no 'Personal.xls' file in the list, you will need to seek additional help or look in your backups.

We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our.

By clicking ' I AGREE' below, you agree to our and our personal data processing and cookie practices as described therein. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted. Outlook for mac 17030901 new email

Personal Macro Workbook in the startup folder must stay open for recording. Nov 15, 2005  Hi All, If I do alt-TMR in excel to record a macro, and opt to store the macro in personal.xls, I get a nice 'microsoft excel' OKonly popup telling me 'personal macro workbook in the startup folder must stay open for recording'.