Compilation error in hidden module: ThisWorkBook"

[David Fernandez]

hi,

I receive this error whenener I open Excel 2003,I've been looking for pdf
files in excel folder, but there is none, so can´t take microsoft web page
solution.

does anybody know where to look for a solution

after error message the program works nicely.

thak you very much.

 

[Socko]

If you have the code written to a module with the project locked for
viewing, then the system cannot show the error that it encounters. the
message then would say "Compile error in hidden module :
ModuleName"..

To resolve and debug the code, please remove the password :
Go to project explorer, right click the project, select vbaproject
properties, click protection tab, and in the tab, unclick "lock
project for viewing"... and remove password. This will ensure you are
able to debug the problem encountered.

I hope this helps.

Selva V Pasupathy
For more on Excel, VBA, and other resources
Please visit: http://socko.wordpress.com

 

[Dave Peterson]

The error could be in any workbook that opens when you open xl2003.

That means the workbook could be:
an addin (tools|addins)
or
the workbook could be located in your XLStart folder
or
it means that the workbook could be in the folder that's in
Tools|Options|general tab|"At startup, open all files in:" box

Chip Pearson has some notes on how to diagnose startup errors:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes:
http://www.jkp-ads.com/Articles/StartupProblems.asp

 

[David Fernandez]

thank you very much for your answers

if it doesn´t solve it, I´ll tell you.

thanks again for your help