[Jeminar]

Can anybody help with a problem I have been having for about 2 weeks, (since I got a new laptop).

Two (completely different) excel/VBA programs stop often and exactly as if control-break has been pressed. There is no rhyme or reason, and the break line is random, and there is not reason for the program to break there. Pressing 'Continue' alleviates the problem.

I thought it might be a glitch on the new laptop, but it has started happening on other people's machines when they are running my code.

I am writing in Excel XP, but it also happens in 2000. It happens if the VB screen is open of not open. It happens on desktops and laptops. Whichever, it is always these two programs and my code.

There is stuff on webferret about this, mainly pointing to something about threads getting out of sync during compile; so I set background compile to off. No fix. Other people have said that rebooting was a permanent cure, but no; not for me.

Some usermanuals for software describe instructions to client to click 'Continue' when this happens. Sounds like the problem was too hard for them fix.

Finally, the searchengine comments about this come as often from Word and Access, as from Excel.

Does anyone know what I have done to confuse VBA? And what can I do to fix it?

[SteadVex]

This is my first peice of advice so forgive me if its wrong.

But i've read on these forums that sometimes this type of thing seems to happen (what your experiacing) and i read somewhere its the way it compiles it or something, if you export all the vba code then import it *mite* work,

or copy each module, delete the contents then repaste it in, to me it sounds crazy and someoen correct me if i miss read this

[Jeminar]

Thanks. Sounds like another fix I know for cells that won't calculate automatically: use find replace to replace all the "=" signs with "=" signs. Occurs regularly in complex vlookup workbooks. I will try this and see what happens. It is very sporadic, so it'll be a few days until I can trust it!