worksheet_change does not fire when a cell is altered via data drop down.
This works on Excel 2000 but not on Excel 97
Can someone out there help!