I have a workbook w/ 10 or so sheets and I want to put in an event handler
to call different macros if different cells are changed by the user. For
testing I've tried putting the following routine in one and all of Modules
1-5 of the workbook project, but can't seem to get it triggered. What am I
doing wrong?

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
MsgBox "Range " & Target.Address & " was changed."
End Sub

Hi John,

Worksheet event procedures should be placed in the sheet module -right-click
the sheet tab, View Code.


---
Regards,
Norman


"John" wrote in message
...
I have a workbook w/ 10 or so sheets and I want to put in an event handler
to call different macros if different cells are changed by the user. For
testing I've tried putting the following routine in one and all of Modules
1-5 of the workbook project, but can't seem to get it triggered. What am I
doing wrong?

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
MsgBox "Range " & Target.Address & " was changed."
End Sub