Hi MD,

The only way that I can think of at the moment is this - replace Excel's built-in menu options for Insert and Delete with your own routines that perform the Insert and Delete and also do whatever it is that you want to do.

I haven't actually tried this - just thinking out loud!