Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|