Forum Discussion

JohnHoff's avatar
JohnHoff
Copper Contributor
Nov 20, 2021

Enabling Office 2021 Excel Macros on a Mac

I just installed Office Home & Student on my Mac.  An existing worksheet macro will not run. Upon opening the worksheet, I was prompted, as with the previous Excel version, to enable or disable the worksheet macros. The enable button doesn't seem to work as in the past.  The new version of Office Excel for Macs is 16.55

Macros and VBA

4 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Nov 22, 2021
    What do you mean with "doesn't seem to work as in the past"? What does or doesn't it do?
    • JohnHoff's avatar
      JohnHoff
      Copper Contributor
      Nov 22, 2021
      When opening up an older worksheet, I'm prompted to enable/disable existing macros as a security precaution. In the past, I could choose either response by clicking on the prompts. Now with the new version of Excel for Macs, the "enable" option is greyed out and doesn't enable the macros when selected. Hence, my macros don't run.