Compile error in hidden module: Sheet 1 error in Macbook on macros

Copper Contributor

Screenshot 2023-06-26 at 9.29.24 AM.pngHi All,

When i run macros in my Macbook air it gives me the above error. The same i can run on windows machine. Pls help.

5 Replies


It is quite unlikely that anyone in this community can resolve your problem with just that information.

A person who has access to the code in the hidden module Sheet1 must inspect that code to determine the problem. My guess is that the code is written using a Windows-specific feature. There may be a workaround for Excel for Mac, or there may not be.

In short, discuss this with a person who supports this software.


Hi sir......i don't have any such person in my contacts. Can you kindly help me out in case you or anyone of your contacts has any knowledge of the same ?
if possible upload your .xlam file,maybe someone has this kind of knowledge.



Please find the sheet attached. Kindly help.

Sub Complete_Exit() Dim req As New MSXML2.XMLHTTP60

Have you viewed the vba codes?
This New MSXML2.XMLHTTP60 is not available in Mac VBA.

In another words,this vba only run on Windows system rather than Mac Os.

I guess you have to use another way to get information from the web site like PHP or Go.

Or run VBA on windows PC.