|
|
|
|
#1
06-22-2014, 03:02 AM
|
||||
|
||||
Quote:
Just for the record, the answer is yes. You can use the workbook_change event in the ThisWorkbook module. ImageUploadedByTapatalk1403431309.336709.jpg 
|
|
#2
06-22-2014, 05:12 AM
|
||||
|
||||
|
Really? A Worksheet_Change routine in the ThisWorkbook module will work for every worksheet? That's cool, I never knew. I don't think I've ever had to have the same Worksheet_Change logic for every worksheet in a workbook, so (I realize now) I was just assuming.
Wait—what happens if I have a Worksheet_Change procedure in both modules, ThisWorkbook and a worksheet? Does Excel get upset, or does it just let the worksheet override the workbook?
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 automatic entering of multiple words
|
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 |
|
Adding a goal line to a chart
|
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 |
Windows 7 64bit 
Office 2013
Hybrid Mode