View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default 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