Slow Down...

J

James Rose

Hello Again,

Is there any way to pause a macro without pausing everything else in
excel.

Or maybe is there a way to simply slow a macro down ?

Cheers

James
 
D

Don Guillett

This may help you
EnableEvents Property
True if events are enabled for the specified object. Read/write Boolean.

Example
This example disables events before a file is saved so that the BeforeSave
event doesn't occur.

Application.EnableEvents = False
ActiveWorkbook.Save
Application.EnableEvents = True
 
K

KJTFS

Not really sure what you are looking for but DoEvents helps slow down
VBA code and process what ever the user is trying to do in excel at the
time.


Keith
www.kjtfs.com
 
D

David

Pick the macro to rum and step through it - F8, will
allow you to step through the macro and pause it where
you want. If you have "sectioned" the macros you can
type "stop" and certain strategic spots to halt the macro.

'>-----Original Message-----
 
Top