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

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.

---
Per

"Maury Markowitz" <(E-Mail Removed)> skrev i meddelelsen
news:2b7628ef-2a3a-4a42-9751-(E-Mail Removed)...
>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

Thank you!