Compile error in hidden module

[Denis]

When I start Excel 2007 a couple of files load at startup (Common
Macros.xlsm and Personal.xlsb) both of which contain macros. Everything has
been working fine for quite a long time but today I get "Compile error in
hidden module: This Workbook".

I have unhidden both the files and restarted Excel. Common Macros.xlsm
seems to load ok but I get the above message immediately after that, so I
assume the problem is in Personal.xlsb. I am unable to tell which module is
causing the problem - is there some way of finding out which one?

Denis

 

[Jim Rech]

is there some way of finding out which one?


I think you told us - the ThisWorkbook module.

Check Tools, References in the VBE for something 'missing' too.

--
Jim
| When I start Excel 2007 a couple of files load at startup (Common
| Macros.xlsm and Personal.xlsb) both of which contain macros. Everything
has
| been working fine for quite a long time but today I get "Compile error in
| hidden module: This Workbook".
|
| I have unhidden both the files and restarted Excel. Common Macros.xlsm
| seems to load ok but I get the above message immediately after that, so I
| assume the problem is in Personal.xlsb. I am unable to tell which module
is
| causing the problem - is there some way of finding out which one?
|
| Denis
|