Compile Error in Hidden Module: Sheet 1

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I have an entire group that cannot open there projects without receiving this
error. They are all using Excel 2003 sp3. Because of this error, they
cannot view or make any changes to the project. I have checked for anything
in the XLSTART folders and there wasn't anything there. I checked for any
add-ons and they were all unchecked. I checked for all of the listed adobe
files, listed in other forums and it didn't work. I tried going into VB
Editor to check the references AND tried to do a debug and a screen pops up
asking for a password. No one is using a password, so I don't know what
that's about. I am at a complete loss, if anyone knows something, please
help!
 
The project requiring the password, is the hidden module being referred to.
It contains a macro, and that macro seems to have a compile error in it.
Find out what this sheet is all about, and what macro is contained there-in.
You can also change the macro security level to High, if this will disable
the macro. With the macro not runnning, you won't have the problem.
However, it is best to find out who wrote this macro, and what the purpose
is! Press <Ctrl><F11> and again try and open the info in the left hand
window, by double clicking on it. Where there is no code, or then no
protected code, it will open. However, the fill with the protected code will
ask for the password. Make a note of that name, and start playing detective!

--
HTH

Kassie

Replace xxx with hotmail
 
Back
Top