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.

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.

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 :(.


"Bob Phillips" wrote in message
...
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.

Wanna send me the workbook to look at?

--

HTH

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


"Eric" wrote in message
...
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 :(.


"Bob Phillips" wrote in message
...
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.

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

"Bob Phillips" wrote in message
...
Wanna send me the workbook to look at?

--

HTH

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


"Eric" wrote in message
...
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 :(.


"Bob Phillips" wrote in message
...
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.