A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
This is a very common issue. The problem is that the author of the macro did not take the Mac into account and has used features that are not supported in Mac VBA. There is no fix or workaround other than to rewrite the macro to use common features and test on a Mac to make sure this issue does not occur.