A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Hi JoanneNeville1
Greetings! I am Vijay, an Independent Advisor. Did you mean that you saved it in Personal macro workbook. Let me know.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I recorded a macro in excel , however i can't access it . I am looking for some suggestions as to why this isn't running. it was saved as a private Macro sheet. I have checked that macros is on and can run other macros on other sheets. Thanks
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi JoanneNeville1
Greetings! I am Vijay, an Independent Advisor. Did you mean that you saved it in Personal macro workbook. Let me know.
What is the exact issue which you are facing?
Can you open Excel > View tab > Unhide (don't press OK) and let me know if Personal.xlsb is visible here?
Hi I'm Peter an independent advisor, If your macros disappeared, we suggest you locate the file name in the following location C:\Users\******\AppData\Roaming\Microsoft\Excel\XLSTARTSent.
If you're able to find the file click on Macros Button on the Developer Tab and click on the drop down near macros in. From there, you would find Personal Macro Workbook, select Personal Macro Workbook and list of macros saved should appear in the list.
What does "it was saved as a private Macro sheet" mean?
There is no "private Macro sheet" in Excel!
Andreas.