Slow Down...
 

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


---
Message posted from http://www.ExcelForum.com/

Slow Down...
 

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
--
Don Guillett
SalesAid Software

"James Rose" wrote in message
...
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


---
Message posted from http://www.ExcelForum.com/

Slow Down...
 

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


---
Message posted from http://www.ExcelForum.com/

Slow Down...
 

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-----
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


---
Message posted from http://www.ExcelForum.com/

.