Change events and linked cells

[Don Wiss]

I never use linked cells. But some of the users of my programs use this
feature extensively. Now that we have upgraded to Excel 2002 I have been
making extensive use of the cell change event. A user has complained about
some problem with change events not being picked up with linked cells. But
he wasn't able to demonstate if for me. Generally he has multiple
spreadsheets open. What nuances do I need to be aware of with the change
event and linked cells?

Don <donwiss at panix.com>.

 

[Dick Kusleika]

Don

I never use linked cells. But some of the users of my programs use this
feature extensively. Now that we have upgraded to Excel 2002 I have been
making extensive use of the cell change event. A user has complained about
some problem with change events not being picked up with linked cells. But
he wasn't able to demonstate if for me. Generally he has multiple
spreadsheets open. What nuances do I need to be aware of with the change
event and linked cells?

None, I think. A linked cell will undoubtedly have a formula in it (if I
understand you). The Change event will only fire when the user (or a macro)
enters something into a cell, not when the value changes as the result of a
recalculation. What problems did the user have?