Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Third party .xla interferes with Worksheet_Change
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... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Third party .xla interferes with Worksheet_Change
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
3rd party add ins for XL 07 | Excel Discussion (Misc queries) | |||
code interferes with function charts() | Excel Programming | |||
worksheet_change vs. calculate, and worksheet_change not running | Excel Programming | |||
worksheet_change vs. calculate, and worksheet_change not running | Excel Programming |