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

Workbooks("BadAddIn.xla").ToggleFormsDesign

This requires Excel 2003 I believe.

--
Jim
"Sam Wilson" wrote in message
...
| 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...