Personal Macro Workbook In The Startup Folder Must Stay Open For Recording. Excel 2016 Mac5/24/2019 I record a macro or macros and none of them worked the way I wanted. Best mac concealer for dark circles. I kept getting the message about Personl.xlsb workbook each time I open a workbook. I hid personal Macro workbook. Now, I want to record a macro, it states: Personal Macro Workbook in the startup folder must stay open for recording. 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 Hope that helps. Adobe photoshop elements 12 for mac free download 2017. Adobe photoshop elements 12 free download - Adobe Photoshop CC, Adobe Creative Cloud, Teach Yourself Adobe Photoshop Elements 12, and many more programs. Click here to expand the list of things you need to know before you download Photoshop Elements. To download Photoshop Elements 14 and earlier versions, see Download Photoshop Elements| 14, 13, 12, and earlier. Download Adobe Premiere Elements; Twitter™ and Facebook posts are not covered under the terms of Creative Commons. ![]() If you know you have no macros in this workbook, one of the quickest ways to resolve issues with it is to locate and delete the Personal.xlsb. Once it is deleted, problem solved. If you need to record macros to be run in various workbooks again just record a new macro and store it in the Personal Macro Workbook. Excel will create a new PMW in the correct location which should work find. For some very useful info about this workbook and some advice on locating and fixing issues, and follow advice on it. Hello Hans & Rudy, My problem is resolved and Rudi thank you for sending the link; I am going to study it and I am sure, it benefits me. I don't know if I should post it here or not. ![]() I am making charts for my department as many as 120. I built the template and plugged in the data from company's system into a sheet in excel workbook and functions on the new sheet pulled the data from the first data sheet and on the result, I inserted a chart. (lot of manual work and I have been working on it for about 8 days) Throughout this project, once in a while I inserted Macros that each time, I ran into an issue, I wonder if there is an easier way to do these charts, 1-downloading the data from the company system 2-Pasting into a sheet 3-Having function to pull the data 4-Insert a chart Regards, BittenApple Post=180109 5StarLounger Posts: 1007 Joined: 01 Mar 2015, 02:03.
0 Comments
Leave a Reply. |