Ctrl Break Mode Stuck

cwelch

New Member
Joined
Mar 2, 2019
Messages
5
I wrote VBA Code.
Upon execution I hit CTRL BREAK.
Now everytime I run the code it stops on the same line of code. Highlighted in yellow.

What I've tried:
I have hit stop in code.
Have selected CONTINUE.
Have deleted the line and re-entered it.

How can I get this to run straight through again?
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,237
Office Version
  1. 2013
Platform
  1. Windows
Maybe posting the code would help ???
AND
Tell us which line it is !
 

cwelch

New Member
Joined
Mar 2, 2019
Messages
5
Maybe posting the code would help ???
AND
Tell us which line it is !

It's the Show line.
The code ran fine ..... until i pressed Ctrl-Break.
Now everytime it runs it stops in break mode on that line.

Private Sub Document_Open()
Application.DisplayAlerts = wdAlertsNone
JVS_Externship.Show
End Sub
 

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,237
Office Version
  1. 2013
Platform
  1. Windows
Ok, so uncheck the break line....click on the little brown dot on the LH side of the code window !
 

Watch MrExcel Video

Forum statistics

Threads
1,108,501
Messages
5,523,293
Members
409,508
Latest member
Afc

This Week's Hot Topics

Top