-
Ok. When the user opens up my form in excel, a form comes up with three buttons. Well, it seems to me that when ever VBA feels like it, it throws up a compile error:
Compile Error in hidden module: frmReferral.
frmReferral is the name of my form. Could someone tell me why this is happening. And when I go in to see whats wrong, I delete a part of the code, then put it right back, open it up and it doesn't do that anymore. It seems to me that there is a glitch some where. If you would like to look at the file let me know. Thanks
-
Somebody please take a look at this. I really need this help. Joacim? Are you there. Somebody. Please
-
Try unprotecting the VBA code that is calling frmReferral form and any other VBA code that might be triggering this message.
My guess is that you have made an incorrect statement in protected code, then VBA can't jump to the statement that is generating the error and comes up with this Compile error in hidden module.
hope this helps....
-
Haveyou tried sepping though the code in the module ?
Sometimes there is a more useful message.