Partake?
I am working in a workbook where one of the worksheets (“Table1”) with an external link to a web query that is updated every five minutes. The web query is massive, so the one relevant line of data has a link to a second sheet called (“Data Store”).
My macro is an event handler (“Worksheet_Change”) that upon the change of the data in the cells, copies that 1 line and transfers it to the third and final sheet called (“Historical”) Historical is supposed to be like a list/tally sheet so that macro code has an activecell offset paste function built in.
I know about Applcation.EnableEvents and turning that off for the duration, however it does not work! I have done this before in Excel 97, but Excel 2000 -no.
I have tried dozens of different ways, but so far I have had no luck.
I have just newly upgraded to Excel 2000 from Excel 97 and I wonder if possibly I am missing something.
Using the menus and/or pushing F5 to execute my macro does absolutely nothing…no error, no action, nothing.
What could be wrong? I recently had to have my hard drive wiped and re-installed…could it possibly be that the problem that prompted that could not be fixed yet, or are there special declaration statements or set-up procedures that Excel 2000 needs to run an event handler? Any experience? Any clues?