Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can Worksheet_Change be placed somewhere "universal"?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can Worksheet_Change be placed somewhere "universal"?
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" skrev i meddelelsen ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can Worksheet_Change be placed somewhere "universal"?
Thank you!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Worksheet_Change Triggers on "Delete" but not on Data Entry | Excel Programming | |||
How so I make a "Worksheet_Change Event" to show cell changes in Excel? | Excel Programming | |||
How do I make a "Worksheet_Change event" to show any changes to cells? | Excel Worksheet Functions | |||
Worksheet_Change Event "Circular Reference" | Excel Programming |