Code for Last Operation

Hi,

Anyone knows if there is a VBA code that identifies the last operation that was performed by a user in an Excel sheet? For instance if someone pasted ALL. Then I want to identify the operation "paste all" and undo the last operation by using Application.Undo inside the event Worksheet_Change().

I very much doubt it. The worksheet change event handler responds to the fact that a change has been made to one or more cells. The Target identifies what has been changed but not how it came to be changed. And the Undo operation undoes the last change, and only the last change.

.
I really enjoy reviewing the questions posted on this FORUM. Inevitably, the unassuming questions result in a wonderful learning experience for me !

Joakim N ... THANK YOU for you question.

Now ... this may not be the end all you were seeking but it does answer your example question. Paste the following into the Sheet Level Module :

Please Login or Register  to view this content.

Presently, the above macro only provides a MsgBox notification that a 'PASTE' occurred. You can add to the code to allow for logging info related to the paste.