Rich,

VBA code is copied over using the VBIDE library which gives access to
all VBA project properties and modules and their contents. This however
also triggers security warnings when you change this through code
(viral behavior), and the VBIDE library might also be not installed
(not standard).

Why not using workbook events or class modules to generalise sheet
events?

DM Unseen