Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inconsistent behaviour Stop Statement
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inconsistent behaviour Stop Statement
Just have tried this at work and still not working, so moving the Stop
statement a few statements down didn't solve it. RBS RB Smissaert wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inconsistent behaviour Stop Statement
Hi Bart,
No idea why that doesn't work, maybe this might If ActiveSheet.Range("A1").Value = "error" Then On Error GoTo 0 N = 1 / 0 'err.clear / resume original error handling End If Regards, Peter T wrote in message oups.com... Just have tried this at work and still not working, so moving the Stop statement a few statements down didn't solve it. RBS RB Smissaert wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inconsistent behaviour Stop Statement
Hi Peter,
So, On Error GoTo 0 N = 1 / 0 comes in place of Stop? Will give that a try, thanks. RBS "Peter T" <peter_t@discussions wrote in message ... Hi Bart, No idea why that doesn't work, maybe this might If ActiveSheet.Range("A1").Value = "error" Then On Error GoTo 0 N = 1 / 0 'err.clear / resume original error handling End If Regards, Peter T wrote in message oups.com... Just have tried this at work and still not working, so moving the Stop statement a few statements down didn't solve it. RBS RB Smissaert wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |