Forum Discussion

bigjim1216's avatar
bigjim1216
Copper Contributor
Jan 30, 2022

Excel will not let me record a macro

I have been working on a workbook that contains several macros that I wrote and some that I recorded.  Never had a problem.  All of a sudden it will not let me record or create a macro.  The workbook is not protected.  I select Record a macro.  The screen comes up asking for the name.  I just use the default, Macro1.  But when I hit OK, it does nothing.  I can run existing Macros, but I cannot create a new one.  Does anyone know what is going on and how I can fix it?

 

thanks,

 

Bigjim

4 Replies

  • Patrice Brel's avatar
    Patrice Brel
    Copper Contributor
    Good afternoon, please verify how your macros work:
    Home>Options>Trust Center > Trust Center Settings > Macros settings>... Choose enable VBA. Regards
    • bigjim1216's avatar
      bigjim1216
      Copper Contributor
      Thanks for the promt reply. I already did this. I have Macros enabled. All my other macros in this workbook work fine. Just can't record a new one. It does nothing when I click on record macro. Also if I want to just creat a new one, It won't let me click on Create when I open the Macro box. Again all my other macros are there and work fine, just can't do a new one. I thought maybe I had exceeded the limit to how many I could have in a workbook, so I deleted one but that didn't help.

      Again, Thanks

      Bigjim
      • Patrice Brel's avatar
        Patrice Brel
        Copper Contributor
        Hello,
        With a new file.xlsm do you also have this problem ?

Resources