Got focus ?

[Fixador]

Something weird .............

1 pc on xp pro
1 instance of BA v63 2 tabs in use
1 instance of Excel - 2 projects running

Whichever excel project xls is displayed on screen - it completes the full set of procedures to anylse data , and places bets

The xls project which is not displayed on screen - starts, but does not complete the set of procedures ( it does the first 6 subs of 12 )

Both projects have subs of the same name - "Option private module" is used throughout. Most variables are declared at procedure level, a few at module level. "Option Explicit" is used throughout .

There is one excemption : The uppermost project control is located in "ThisWorkbook" from whence all module based subs are called. "ThisWorkbook" does not contain "Option private module" - as disallowed here.

No where in my vba is their a "Select" command !

Any ideas - anyone ?

[osknows]

Make sure there's no Activeworkbook/ActiveSheet in code..?

[Fixador]

hi osknows - no there are none of either of those

Added - if i run 1 project at a time - there is no problems

[osknows]

Nothing particular stands out (needle haystack..) but perhaps the CALL commands contain something?

The best thing to do is open both instances, ALT-11 into the VBA code and put a break point in both bits of code and cycle through using F8

[Fixador]

cheers osknows - advise taken.

This has being bugging me for sometime. Today is the first time i have seen it so clearly - it screamed at me !