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?

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: 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?

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
TreeView - JavaScript IE / FireFox IFRAME Combination
http://www.eggheadcafe.com/tutorials...script-ie.aspx

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

<Ian Gooden wrote in message ...
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: 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?

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
TreeView - JavaScript IE / FireFox IFRAME Combination
http://www.eggheadcafe.com/tutorials...script-ie.aspx