Worksheet_change won't run

E

Eric

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.
 
B

Bob Phillips

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)
 
E

Eric

Sheet1 is where I am trying to make this all happen and double checked,
actually I think it is approaching the umpteenth time that I have checked
that I do have the code in the 'Sheet1' class module, not a standard code
module. I am so confused :(.
 
B

Bob Phillips

Wanna send me the workbook to look at?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
E

Eric

It contains proprietary company information so that isn't an option. But
weird as it may seem, and having done nothing more than log off my computer
last night and log back in this morning, it is working today. Welcome to
the world of Microsoft, I guess. Thanks for your interest and help though.

Eric
 
Top