Forum Discussion

kaupper's avatar
kaupper
Copper Contributor
Apr 07, 2022
Solved

Excel "Unable to record" macro

Hello,

 

I just installed Microsoft 365 on my desktop running windows 11. I am unable to record macros, view macros on existing workbooks, or create/view VBA projects. Macros are enabled in the macro security settings.

 

Whenever I try to record a macro I get the error message below:

 

 

Whenever I try to open a workbook with existing macros I get the error message below:

 

If I click "No" at this message, excel just goes black:

 

If I click "Yes" I get the following error:

(The "log file" just repeats the "Removed Part" message you can see above)

 

This is reproducible 100% of the time.

I have tried repairing my installation of 365, uninstall/reinstalling 365, contacting microsoft support and running through their procedures, all to no avail.

 

I would really appreciate any help with this issue.

 

Thanks,

 

  • For anyone else having this issue: The issue corrected itself after a fresh install of my OS.

2 Replies

  • kaupper's avatar
    kaupper
    Copper Contributor

    For anyone else having this issue: The issue corrected itself after a fresh install of my OS.

    • Patrick2788's avatar
      Patrick2788
      Silver Contributor
      Were you recording to the Personal Macro workbook? Seems like it was a problem with your XLStart folder.

Resources