You need to make sure that the two settings "Digital Certificate for VBA Projects" and "Visual Basic for Applications" during Excel installation are selected. In the PC version (the Mac version should be similar) run the Installation setup program to get to these options and enable them
Hope this helps. Let me know if you have any questions
Ok could you please check if you can run the macro in this file
And also check if you can record a new macro in that file
Let me know
Also you need to make sure that your Mac user account has Administrative privileges. If in doubt create a new user account with Administrative privileges then reboot and log directly to that account then try to record a macro
Hope this helps
Did that help?