How to catch copy / paste event

dabbieidason

New Member
Joined
Aug 16, 2012
Messages
1
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!
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Forum statistics

Threads
1,089,193
Messages
5,406,732
Members
403,104
Latest member
mkirchner

This Week's Hot Topics

Top