Archive of Mr Excel Message BoardArchive of Mr Excel Message Board
Recently i've run some excel file with VBA on couple PCs. Strangely, only a few of the PCs shows an error message "Compile error in hidden module ControlCopy"
ControlCopy is a user defined module locked with password under Excel's VBA editor.
Any ideas what could trigger the error???
Thanks
Regards,
Darren
:P
Darren the error you get is probably a referencing
error.....the hidden code has a reference to a
Object library file or OCX or Dll or file that
is not present or set on these computers.
Your'll need to get into the project in order to
set this...as it is password protected you cannot
do this. You'll need to get the password in order to fix this.
Ivan