ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Compile error in hidden module: ThisWorkbook (https://www.excelbanter.com/new-users-excel/187977-compile-error-hidden-module-thisworkbook.html)

Slibert

Compile error in hidden module: ThisWorkbook
 
How to Correct the "Compile error in hidden module: ThisWorkbook"? When
opening Excel 2003, now, for whatever reason, I receive a dialog box,
immediately upon opening the program, with the message "Compile error in
hidden module:
ThisWorkbook" What needs to be done, to correct this??

Gord Dibben

Compile error in hidden module: ThisWorkbook
 
Could be this error.

See KB article http://support.microsoft.com/default...;EN-US;q307410

The PDFMaker.xla and maybe PDFMaker.dot are stored in your Office\XLSTART folder
or in the Excel\XLSTART folder.

Any files in these folders will open with Excel.

You must remove them from the XLSTART folder.


Gord Dibben MS Excel MVP

On Sun, 18 May 2008 15:47:01 -0700, Slibert
wrote:

How to Correct the "Compile error in hidden module: ThisWorkbook"? When
opening Excel 2003, now, for whatever reason, I receive a dialog box,
immediately upon opening the program, with the message "Compile error in
hidden module:
ThisWorkbook" What needs to be done, to correct this??



Billy Liddel

Compile error in hidden module: ThisWorkbook
 
I'm guessing that the error is in your Personal Workbook as this is hidden
and opened with Excel. Press Alt + F11 and see if you can see any macros then
Press Debug, Complile Vb Project


If you do not see any macros listed then Press Ctrl + R to view the Project
Explorer. Is there a Line VBProject(PERSONAL.XLS) then if necessary, click
the + Button to open the list and then try debugging each module in turn.

Good luck
Peter

"Slibert" wrote:

How to Correct the "Compile error in hidden module: ThisWorkbook"? When
opening Excel 2003, now, for whatever reason, I receive a dialog box,
immediately upon opening the program, with the message "Compile error in
hidden module:
ThisWorkbook" What needs to be done, to correct this??



All times are GMT +1. The time now is 02:23 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com