"Rob Bovey" wrote in message
...

Hi Alan,

The value of Application.CutCopyMode will tell you whether a user
has a cut or copy operation in progress when your event procedure
fires, something like this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Application.CutCopyMode = 0 Then
''' User hasn't copied anything,
''' run your macro here.
End If
End Sub

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


Hi Rob,

Your code did the job perfectly.

However - once I made that change, I noticed that the less excel literate
users were filtering the list, and copying down through filtered rows, thus
trashing everything in the 'hidden filtered' rows that are not shown.

I should have anticipated this, but due to the 'bug' that you helped me
resolve, it had not been an issue due to the 'disabling' of the copy / paste
functionality.

Therefore, I have actually removed the code that you supplied, and returned
it back to the original position.

The 'bug' have now been re-designated as a 'feature'!!

Thanks anyway - I learnt something if nothing else.

Regards,

Alan.