Share via

Macro not saving in Excel

Anonymous
2019-08-06T06:01:17+00:00

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

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments No comments

6 answers

Sort by: Most helpful
  1. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2019-08-06T06:16:06+00:00

    Hi JoanneNeville1

    Greetings! I am Vijay, an Independent Advisor. Did you mean that you saved it in Personal macro workbook. Let me know.

    6 people found this answer helpful.
    0 comments No comments
  2. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2019-08-06T07:57:11+00:00

    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?

    1 person found this answer helpful.
    0 comments No comments
  3. Anonymous
    2019-08-06T07:04:53+00:00

    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.

    1 person found this answer helpful.
    0 comments No comments
  4. Anonymous
    2019-08-06T07:05:11+00:00
    0 comments No comments
  5. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2019-08-06T06:11:19+00:00

    What does "it was saved as a private Macro sheet" mean?

    There is no "private Macro sheet" in Excel!

    Andreas.

    0 comments No comments