Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow Tab | Excel Discussion (Misc queries) | |||
VERY SLOW | Excel Discussion (Misc queries) | |||
Slow Excel Navigation with Up / Down Arrow and slow scrolling | Excel Discussion (Misc queries) | |||
Why Del is Slow | Excel Discussion (Misc queries) | |||
Why so slow | Excel Discussion (Misc queries) |