Can Worksheet_Change be placed somewhere "universal"?

[Maury Markowitz]

I have a workbook with many tabs, and the number often changes. Most
of these tabs have columns that need to call code when certain cells
change. The code in incorporated into another workbook that is always
opened.

I call the code by placing a Worksheet_Change event hander VBA macro
in every sheet. The problem is that if the macro changes, say it moves
to a different workbook or the API changes, I have to go to all of the
sheets and change the code that calls it.

Can I put this event handler somewhere else? Does the _change message
"bubble up" to some higher layer, like ThisWorkbook?

Maury

 

[Per Jessen]

Hi

You can use a Workbook_SheetChange event.

The code is to be in the code sheet for ThisWorkbook.

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
'Your code
End Sub

Hopes this helps.

 

[Maury Markowitz]

Thank you!