Tegger,

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

XYZ


End Sub

Put this in the worksheet cod module.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"tegger" wrote in message
...
How do I do this?

Whenever the user changes anything on sheet1 to have the macro xyz run on
sheet3.


--

DL