Worksheet_change won't run
I am running Excel 2000. I have a spreadsheet that I am trying to add some
data-mining instructions to the Worksheet_change macro. The spreadsheet is
a means of tracking manufacturing progress and is linked to other
spreadsheets. I have run a macro to make sure the Application.EnableEvents
= True has been set. Yet the Worksheet_change macro will not fire when any
cell on the sheet containing the macro is changed. Is there a switch I am
not aware of? Any suggestions outside of 'give up and go home' will be much
appreciated :). Please help.
Thanks in advance.
|