Yn newyddion: ,
Roedd Peter T <peter_t@discussions wedi ysgrifennu:

I've amended your routine slightly and with the test all seems to
work OK. Having said that, there are scenarios where adding event
code to class modules can cause the project to recompile and crash
Excel (eg under certain circumstances when adding new code to the
project that's running the insert new code).

If the following doesn't work it's probably related to what you are
doing overall.

See also the CreateEventProc method.

Rb