compile error in hidden module with excel 2003

  • Thread starter Thread starter Brian Murphy
  • Start date Start date
B

Brian Murphy

Hello Excellers,

I have a user that is using Excel 11.0, build 5612 (Excel 2003). When he
starts up my addin he gets "Compile error in hidden module: myModule_Name".

I have tested with excel 11.0, build 6113, and I don't get any errors.

Does anyone know what the problem might be?

Thanks,

Brian Murphy
Austin, Texas
 
I find that most the time this is due to an unrecognized constant (like
xlABC), but it should be easy to debug. Just unlock the VB project in the
add-in and then the module won't be "hidden" any more so you should get a
Debug button with the error message.

--
Jim Rech
Excel MVP
| Hello Excellers,
|
| I have a user that is using Excel 11.0, build 5612 (Excel 2003). When he
| starts up my addin he gets "Compile error in hidden module:
myModule_Name".
|
| I have tested with excel 11.0, build 6113, and I don't get any errors.
|
| Does anyone know what the problem might be?
|
| Thanks,
|
| Brian Murphy
| Austin, Texas
|
|
 
Thanks, Jim.

I was already thinking about sending him an unprotected addin to see what
that would tell me. So now I'm definitely going to do that.

Based on some recent changes I've been making, I can see that it might be a
bum constant name.

Brian
 
Back
Top