How to catch copy / paste event

[dabbieidason]

First of all I want to thank you guys for this forum. Helped me to many times!

But now I'm pretty stuck on one problem.

My workbook use protection. Special cells are locked if not empty. I use WorkSheet_Change(), when some cell is changed, every locked cell will be protected and need to unprotect worksheet if I want to change locked cells.
This works like a charm, buuuut...

If I copy any row, and then paste it somewhere it will do (if the worksheet is unprotected).
But apparently WorkSheet_Change() doesn't think paste is any change, and the worksheet is unprotected.


It would be great if there is some event handler to catch paste event (then I could just simply lock the worksheet), but I haven't find any.

Any advice?

Thanks alot guys for everything!