Enabling Office 2021 Excel Macros on a Mac

[JohnHoff]

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

[#2]

What do you mean with "doesn't seem to work as in the past"? What does or doesn't it do?

[#3]

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.

[#4]

@JohnHoff Set it to this option: