Where have you put the code? It should be in the sheet class module, not a
standard code module.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Eric" wrote in message
...
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.
|