Compile error in hidden module. Module 1

[neo2]

Hi Guys,

I am getting the above error message whenever I try to open up my spreadsheet. I am using excel 2010 currently but the sheet was created in excel 2007. How can I solve this ?

Neo

 

[sfccato]

I have the same problem, but cannot select "references" from the tool menu as it is greyed out, any suggestions? Thanks.

 

[RoryA]

You can't change the references if code is running (click the Stop button on the toolbar in the VB Editor) or if the project is protected.

 

[scrybbler]

I had this error as well because my code was secured by a password. Once I opened the code editor and unlocked, it gave me a normal error message that I could debug.

 

[meenanke]

A compile error can also occur as result of 32- and 64-bit Excel conflicts (i.e. file includes macros created in Excel 32-bit, but has an error when opened by someone running 64-bit Excel)

 

[chirag050675]

A compile error can also occur as result of 32- and 64-bit Excel conflicts (i.e. file includes macros created in Excel 32-bit, but has an error when opened by someone running 64-bit Excel)

Dear All,

Yes This Is true , 32 Adding run in 64 bit Office cause this.

But What is solution if we want to run this macro(32 bit) in 64 bit?

Regards,

Chirag Raval

 

[RoryA]

If you're using API calls, you need to use conditional compilation to make them work in both 32 and 64bit. See: https://www.jkp-ads.com/Articles/apideclarations.asp