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 - 17 Dec 2007 15:19 GMT
>>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.

Signature
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
[quoted text clipped - 7 lines]
|
| Denis