I don't think you can intercept this message and make it do what you want.

In fact, I don't think you can do much with a compile error.

But you could compile your project before you release it to others.

Inside the VBE
Debug|Compile VBAProject




BernzG wrote:

Hi,

I have password protected my excel macros and thus they are hidden from
others that use it.

However when there is a 'compile error' I automaticly receive an error
message
"Compile error in hidden module:Module1".

Is there any way that I can change that error message to read something
like this :-

"Complile error - contact Bernz and advise exactly what you were doing
at the time of the error message"

Cheers,
Bernz

--
BernzG
------------------------------------------------------------------------
BernzG's Profile: http://www.excelforum.com/member.php...o&userid=22949
View this thread: http://www.excelforum.com/showthread...hreadid=388193

--

Dave Peterson