Hi, I understand there is a "Worksheet_Change()" event that kicks i
once a cell's value has been changed. I have a cell where to there i
a pick list to pick a value, but once this is done the Change() even
doesn't kick in. Nor, does the calculate event. (I can't get th
calculate event to work for anything, but thats besides the point :)

Anyway, does anyone know how to access this. Essentially, i'd like t
update all the other cells that reference this pick list cell when th
pick list cell has been modified. The way I was going to do it was us
the event, and basically do a Worksheets("Sheet1").Calculate whic
would update those values as well as others.

I'm using Excel 97 :< Any help would be appreciated. Thanks

--
Message posted from http://www.ExcelForum.com