Quote Originally Posted by samuraial View Post
Compile error in hidden module:Run GE File

Same for all the other save as etc...

B/R
Solution:

Excel shows a "compile error in hidden module: thisworkbook" when opened or closed.
This error occurs because 2 excel files are corrupted.

To stop the error from occurring:
If in Windows XP open the following folder:
C:\Documents and Settings\USERNAME\Application Data\Microsoft\Forms where USERNAME is the current user

If in Windows 7 open the following folder:
C:\Users\USERNAME\AppData\Roaming\Microsoft\Forms where USERNAME is the current user

Once the folder is located, delete these 2 files
ComctlLib.exd
MSComctlLib.exd
Excel should now open without the error message.
Note: Excel will create 2 new files (with the same names) in the folder, but they will not be corrupted.