Message Box

I don't know whether this is possible but I would like to create a message box to overrise the RunTime Error message "1004"?

I don't want users to be able to de-bug.

Can anyone help?

Thanx
Alex

Good morning alexandra60

Try using the line

Please Login or Register  to view this content.

fairly early on in your code. This will mean that if your code hits an error, then that line will be ignored and the next line will be executed. You really should try and build in some kind of error reporting system though, so users know if there has been a problem and if the routine hasn't executed properly.

Alternatively, password protect the VBE. If you do that, then the code will still stop, but the option to debug will be ghosted out.

HTH

DominicB

Hi alexandra60

If you want further help, can you post (at least) a portion of your code and point out at which place it falls down. Then perhaps someone can advise you how to trap it without using OnError.

HTH

DominicB