Code Constantly Breaking

[Rofeu]

Hello,

I'm sure I'm just overlooking a setting or something simple like that, but I can't find it.

I went from Excel 2000 to 2002 and all of a sudden code in my workbooks breaks for no apparent reason. There's no error and on clicking continue it just resumes only to break again after a few lines etc. etc.

I thought it must have had to do with my settings, but now the same thing is happening to a colleague. I had previously used the file, so it seems something got switched and saved with the workbook.

Does anybody have any ideas on what might be causing this and, more importantly, how to fix it?

Any suggestions will be highly appreciated.

Cheers,

Roel

 

[xlbo]

please define "breaks"

do you mean a code line break or that it doesn't work ? if it doesn't work HOW does it not work

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Fenrirshowl]

By breaks do you mean it's like an error occurred and you break to the highlighted line of code in the VB editor?

I seem to remember this happening to me about 6 years ago, and it was equally odd. I think the problem went away when the macro was retyped (not pasted) into another module. I know this should not have done anything but it did seem to work. (Then again, the original code had no errors and should not have died in the first place!)

Fen

 

[Rofeu]

Hi,

it breaks as it would when you hit [ctrl][break].

Strangely enough it stopped happening on my machine now, but my colleague still has the problem.

Cheers,

Roel

 

[xlbo]

It may just be that you need to re-save the file....have seen this before and it went away after I did a save as the new version

Other than that, you may try adding and removing a new break line and then saving or stepping through the code, line by line and then saving

The cause for me btw was saving the workbook with a break point still active - the visual representation of the breakpoint disappeared but the code still "knew" it was there...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Rofeu]

Hi,

thanks for the feedback. I mucked around with the file and it has stopped breaking (for now). I have no idea what I did to make it stop.

I don't think it is caused by a saved breakline in my case as it doesn't just break in one point but in literally dozens and not at the same lines all the time. (I'm sure I didn't put in that many breaklines)

I'm sure you'll see this thread expanding if I get it again.

Cheers,

Roel

 

[Ed2020]

I've had this in recent versions of MS Access as well. It seems to remember where there *used* to be break-points entered. It even persists on closing the application and re-opening.

Very annoying!

Ed Metcalfe.

Please do not feed the trolls.....