![]() |
#9
|
||||
|
||||
![]()
It's a hierarchy Bob. In this case it's two levels.
Starting from the lowest level: Worksheet Workbook or Application It's actually called Workbook_Sheetchange in fact. The event cascades from bottom (sheet) to top (book), it's easy enough to check the order with msgbox. A couple of events, for example mouse events have a Cancel parameter which can be set to True to stop the cascade at that level but the Sheet Change event is not one of them. The Sheet Change events are however raised sequentially, so the worksheet level event handling routine (if present) is run to completion before the workbook (application) level event is raised. Thus avoiding the potential for conflict. The reason I say workbook (application) is because they are one in the same thing. It's complicated, but when you add a Workbook_SheetChange routine in the ThisWorkbook module you are actually processing the Application.SheetChange routine. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
cliff@tauruscommercial.ca | Word | 5 | 06-03-2014 06:06 PM |
set daily goal for actual workdays, excluding weekends holidays and days off | Brian Reilly | Excel | 1 | 01-24-2014 11:56 PM |
Excel 2007 - formula or macro/vba code required | wrighty50 | Excel Programming | 3 | 05-13-2012 02:24 PM |
![]() |
uhlersa | Excel | 1 | 01-16-2012 08:18 PM |
Normal.dot Help? Fatally Corrupted; No Fix. Please Assist. | atm0073 | Word | 2 | 09-21-2009 04:02 AM |