button to break/stop/pause all macros

**alexandruc** · 10-29-2009, 08:56 AM

Hello,

Is there a command that can be triggered via VB (a button on a sheet) that will have the same result as pressing the "||" pause/break button in VBA Editor?

What I need a button that will disable/enable (break/run sub) all macros in the workbook. Is it possible?

Thanks

**Rick_Stanich** · 10-29-2009, 09:35 AM

Use key commands.
"Control" then "Break"

The Break key is sometimes labeled with two names:
"Pause" and or "Break".
Hold down "Control" key and then press "Pause\Break" key.
This should stop any macro.

**royUK** · 10-29-2009, 09:40 AM

Originally Posted by alexandruc

Hello,

Is there a command that can be triggered via VB (a button on a sheet) that will have the same result as pressing the "||" pause/break button in VBA Editor?

What I need a button that will disable/enable (break/run sub) all macros in the workbook. Is it possible?

Thanks

You can't click a button whilst nother macro is running