the code worked fine for me. I created no references. the event created
worked fine after I executed the code.

I am testing in xl2003. I have had problems with CreateEventProc in the
past in some earlier versions. Try it on a new workbook.

--
Regards,
Tom Ogilvy

"Les Stout" wrote in message
...
Hi Tom, I tried your new code and still get the result below, i just
cant understand it ?

"Microsoft Excel has encountered a problem and needs to close. We are
sorry for the inconvenience."

Do i perhaps have to declare references or something ?

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***