Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 97 - Inconsistent Change Events
I have, through a great deal of trial and error, deduced that some
things appear to suppress the normal execution of the Workbook_SheetChange and Worksheet_Change events. For example, if a cell uses Excel's Validation feature, changes to that cell will not trigger execution of the Change events. Also, it appears that if a cell has a Comment that the Change events are likewise suppressed. The reasoning behind this design escapes me, but I have resigned myself to those inconsistencies. My problem is that there is apparently some other property of a cell that will also suppress the execution of the Change events, but I have been unable to isolate what it is. I have two cells, one is R273C2 and the other is R274C2. Whenever I type a new value into the former, the Change events fire as expected. But when I type a new value into the latter, the Change events are not executed at all. If I hit the Delete key in either cell, the Change events are executed. Neither cell uses Validation or Comments. Indeed, I have taken great pains to insure that NO cells on the entire Worksheet use either Validation or Comments. I have copied the formats of R273C2 to R274C2, but no change was evident. Then I copied the entire cell R273C2 to R274C2, but still no change. I began to think that it had something to do with Row 274, so I checked cell R274C9, but it worked as expected and triggered the Change events. The cells I have referenced are actual cells. However, I also have the same problem with other cells. I'm sure that there must be some other "exception" other than Validation and Comments, but I am just missing it. I have also ensured that no cells use any Conditional Formats, as that seemed a likely candidate, but it was not the problem. The problem apparently has nothing to do with Precedents or Decendents, because none of the cells in question reference or are referenced by any other cells. Can someone please shed some light on this frustrating situation? Is it documented anywhere that Validation and Comments suppress the natural function of the Change events? If so, is it also documented that there are other properties that will do likewise? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine 2 worksheet change events | Excel Discussion (Misc queries) | |||
what is inconsistent formula in region in excel? | Excel Discussion (Misc queries) | |||
Dates display inconsistent in MS Excel 2007 | Charts and Charting in Excel | |||
Cell change events | Excel Discussion (Misc queries) | |||
Migrating Excel Data with inconsistent formats | Excel Discussion (Misc queries) |