Guide

1. While your Microsoft Excel worksheet is currently in use, press the 'Command' and 'Comma' keys simultaneously to open the Preferences panel.

2. After that, head over to the Sharing and Privacy section and then tap select 'Security' from the available options.

3. Finally, click 'Enable All Macros' under Macro Security. The changes will take effect immediately, allowing you to run and use Microsoft Excel macros.