"Compile error in hidden module: This WorkBook" only appears when project locked
- From: Craig <craig.wenger@xxxxxxxxx>
- Date: Mon, 17 Dec 2007 14:06:10 -0800 (PST)
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?
.
- Prev by Date: Excel query record count differs from MS-Access count
- Next by Date: Dynamically adding vba modules to word application
- Previous by thread: Excel query record count differs from MS-Access count
- Next by thread: Dynamically adding vba modules to word application
- Index(es):
Loading