| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I pause a Macro whilst it is running?
I have a macro which simply switches between two
worksheets, but I would like to pause the macro so that it shows one worksheet for say 2 minutes and then switches to the next worksheet for say 2 minutes and then starts again. I know how to loop - it is just the "pausing" that I cannot work out. Does anyone have any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Status bar (or similar) to appear whilst running a long macro | Excel Discussion (Misc queries) | |||
| How to Mute/Enable Windows Sounds whilst running VBA code | Excel Programming | |||
| How to Mute/Enable Windows Sounds whilst running VBA code | Excel Programming | |||
| Programing a macro to pause while running for data entry | Excel Programming | |||
| How to Pause or Stop a running Macro | Excel Programming | |||
![Gary[_20_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
