Slow Down...

  • Thread starter Thread starter James Rose
  • Start date Start date
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
 
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
 
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
 
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-----
 
Back
Top