In an excel sheet the cell types of a column are "named
list" type.The named list refers to a range of cells.
In each cell values are to be selected from the list only.
On selecting an item from the list ,specific actions are to
be done depending on the value of item being chosen.For
this macro has been written in the Worksheet_Change event.
This macro is working fine in Excel 2000. But in Excel 97
this macro is not working .Infact, worksheet_change() event
is not getting fired in Excel 97 for the action of
selecting items from a named list.Is it a problem with
Excel 97 ?