Share via

Compile error while enabling macro

Anonymous
2016-08-16T16:45:42+00:00

I am using a macro enabled excel file which works perfectly fine with Windows OS. But when using the Mac OS, I get the following error: COMPILE ERROR IN HIDDEN MODULE when enabling the macro

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2016-08-16T17:41:23+00:00

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.

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

0 additional answers

Sort by: Most helpful