Hi,

Is it possible to check if when the user clicks a new worksheet
(Worksheet_Activate()) if they have/are coping something - then run
something but then continue the copy command?

i.e.

Private Sub Worksheet_Activate()

'if the user is trying to copy'n'paste something between sheets/workbooks,
first

With ActiveSheet.PageSetup
.LeftFooter = "&Sheet Footer information"
End With

'now continue copy'n'paste

End Sub