CODEWITHSUNDEEP
vbscriptexcelvba
Damian
Damian

Reputation: 4641

Clear All Breakpoints in VBA from VB script

How can I Clear All Breakpoints in a VBA module from VB Script?

I need to make sure my VBA code always runs though, but sometimes I debug it and forget to remove all breakpoints.

Upvotes: 1

Views: 2340

Answers (3)

Habib
Habib

Reputation: 11

stick it to initialization VBA module -- SendKeys "^+{F9}"

Upvotes: 1

MrP
MrP

Reputation: 11

You can clear all breakpoints by pressing CTRL SHIFT F9 - or by selecting the 'clear all breakpoints' from the debug menu

Upvotes: 1

Damian
Damian

Reputation: 4641

If I close the Excel and open the workbook again the points are gone.

I have confirmed that in Office 2007 on Windows 7.

Thank you for the hint.

Upvotes: 1

Related Questions