user changes sheet1 - have the macro xyz run on sheet3

  • Thread starter Thread starter tegger
  • Start date Start date
T

tegger

How do I do this?

Whenever the user changes anything on sheet1 to have the macro xyz run on
sheet3.
 
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)
 
Back
Top