Change events and linked cells
 

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.

Change events and linked cells
 

Don

"Don Wiss" wrote in message
...
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?

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com