LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Formula Formatting - How to Add a STOP Statement rhg Excel Worksheet Functions 4 August 15th 09 06:35 PM
If statement - can it stop once a conditon is reached? mike Excel Worksheet Functions 1 July 10th 09 07:56 PM
If statement to stop Macro Ernest Lai Excel Programming 2 September 28th 05 03:01 PM
If statement to stop macro AK Excel Programming 3 June 29th 05 11:41 PM
DDEInitiate inconsistent... Jeff Brush Excel Programming 0 January 12th 05 08:42 PM


All times are GMT +1. The time now is 07:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"