Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
To get to the bottom of a problem that proves difficult to pin down I have
added a conditional Stop Statement to the Workbook_Open event of a .xla add-in. This add-in will not be loaded as an add-in (no tick under Tools, Add-ins) but gets opened by another add-in. So, add-in 1 does: Open strAddin2FullPath and in the Workbook_Open event of this add-in 2 I have: If Cells(1) = "stop" Then Stop End If This comes directly after the Sub header and after some local variables. On the home setup (Excel 2003, Windows XP) this works fine, so it will step nicely through all the code of the Workbook_Open event of add-in 2. At work though it stops at the line: Open strAddin2FullPath of add-in 1and goes no further. I have now moved the Stop statement down in that Sub a bit, so some other code lines will run before the Stop and hopefully that will solve it. Any ideas/suggestions here? RBS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Formula Formatting - How to Add a STOP Statement | Excel Worksheet Functions | |||
If statement - can it stop once a conditon is reached? | Excel Worksheet Functions | |||
If statement to stop Macro | Excel Programming | |||
If statement to stop macro | Excel Programming | |||
DDEInitiate inconsistent... | Excel Programming |