Thread: Slow Down...
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default 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/