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: 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/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 news:(E-Mail Removed)...
> 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