Sorry, didn't gather that from your original question. It sounded as though
you were simply trying to copy  the sheet. I'm now slightly confused ... are
you copying the sheet  by hand, or is your code copying the sheet?

If it is code that is copying the sheet, just disable events before the copy
and turn them back on again after it. That should do the trick.