I wasn't able to get the error hander code to run either. But setting up
the error handler (even empty) along with EnableCancelKey = xlErrorHandler
does achieve what you want, doesn't it? It does not close the userform so
Ctrl-Break is effectively negated. You don't have to tell the user it
doesn't work; he can see that and will try something else.

--
Jim Rech
Excel MVP