"Compile error in hidden module: This WorkBook" only appears whenproject locked

[Craig]

I am getting the error message "Compile error in hidden module: This
WorkBook" when I try to run an Excel VBA macro from a toolbar button.
I looked around and found that this happens when a project is locked,
so I unlocked it, expecting to be able to debug now, but surprisingly,
now it works. Unfortunately I cannot allow these Excel macros to be
distributed unlocked because they contain clear-text passwords. It
only happens when I launch Microsoft Excel 2003 normally; if I
directly open the .xls file that contains the macros, it works fine.
Is there anything I can do?

 

[Ian Gooden]

Hi there,

Did you possibly get an answer to your problem - I have the same issue here.
The code etc. works on my machine and a few of my clients but now suddenly on 2 customers - I get the error "Compile Error in Hidden Module: MainPage"

I'm really confused???

Cheers,

Ian



Craig wrote:

"Compile error in hidden module: This WorkBook" only appears when project locked
18-Dec-07

I am getting the error message "Compile error in hidden module: Thi
WorkBook" when I try to run an Excel VBA macro from a toolbar button
I looked around and found that this happens when a project is locked
so I unlocked it, expecting to be able to debug now, but surprisingly
now it works. Unfortunately I cannot allow these Excel macros to b
distributed unlocked because they contain clear-text passwords. I
only happens when I launch Microsoft Excel 2003 normally; if
directly open the .xls file that contains the macros, it works fine
Is there anything I can do?

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
TreeView - JavaScript IE / FireFox IFRAME Combination
http://www.eggheadcafe.com/tutorial...d6c-264bc38d08ee/treeview--javascript-ie.aspx

 

[Tim Williams]

That post you're replying to is almost 2 years old...

The error you're seeing is often a result of a missing reference on the
client PC. You'd need to unlock the project and go to "Tools > references"
in the VBE to see what's flagged as "missing".

Tim