Third party .xla interferes with Worksheet_Change

[Sam Wilson]

Hi all,

I've got a macro that needs to be triggered by a worksheet_change event.
This works fine... unless the user is using a third party product, which
installs a certain .xla

The .xla appears to be watching for worksheet changes too - when a user
changes a cell which contains "=DBGET(..)" there must be a macro which steps
in, writes the new cell value to an OLAP database, and leaves the formula
where it is (a DBGET reads values from the same OLAP database)

I've studied this all closely, and changing a value on a sheet launches the
third party macro first, which runs once but does nothing as the cell changed
doesn't contain a DBGET, but then passes the original, unchanged value, to my
macro, which promptly does the wrong thing entirely.

I've tried closing the .xla file in my code, then re-opening it after my
macro has run, but then I get an error message that excel cannot find a sub
from the third party add-in. Where on earth can it be getting the instruction
to look for this macro from? Is there something else I need to close or
disable?

I'm stumped...

 

[Jim Rech]

Have you tried turning the add-in's event handling off?:

Workbooks("BadAddIn.xla").ToggleFormsDesign

This requires Excel 2003 I believe.

--
Jim
| Hi all,
|
| I've got a macro that needs to be triggered by a worksheet_change event.
| This works fine... unless the user is using a third party product, which
| installs a certain .xla
|
| The .xla appears to be watching for worksheet changes too - when a user
| changes a cell which contains "=DBGET(..)" there must be a macro which
steps
| in, writes the new cell value to an OLAP database, and leaves the formula
| where it is (a DBGET reads values from the same OLAP database)
|
| I've studied this all closely, and changing a value on a sheet launches
the
| third party macro first, which runs once but does nothing as the cell
changed
| doesn't contain a DBGET, but then passes the original, unchanged value, to
my
| macro, which promptly does the wrong thing entirely.
|
| I've tried closing the .xla file in my code, then re-opening it after my
| macro has run, but then I get an error message that excel cannot find a
sub
| from the third party add-in. Where on earth can it be getting the
instruction
| to look for this macro from? Is there something else I need to close or
| disable?
|
| I'm stumped...

 

[Sam Wilson]

Hi Jim,

Yes, I have. The problem persists - it's as if there's an invisible add-in
monitoring worksheet events. Even if I close the add-in and delete it from my
computer the worksheet event still triggers (and then I get a macro not found
error)

It's bizarre. It's not life or death - all I've done is put a button on the
sheet launching my macro rather than using the events.