| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide all windows while macro is running
all i've ever needed is:
Application.ScreenUpdating = False at the beginning of the code and Application.ScreenUpdating = true at the end. -- Gary "Freddy" wrote in message ... My current module opens multiple workbooks, saves them, prints them, then closes them. My intention is to have all this happen but not see it happening in the background. I only want to display a status bar message stating that the macro is running (I have the code to display a status bar message). Any suggestions? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Hide all windows while macro is running
This definately did the trick for me! Seaching for 'screenupdating' didn't
turn up a thing in Excel 2003, though! "Gary Keramidas" wrote: all i've ever needed is: Application.ScreenUpdating = False at the beginning of the code and Application.ScreenUpdating = true at the end. -- Gary "Freddy" wrote in message ... My current module opens multiple workbooks, saves them, prints them, then closes them. My intention is to have all this happen but not see it happening in the background. I only want to display a status bar message stating that the macro is running (I have the code to display a status bar message). Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running a macro from windows application | Excel Discussion (Misc queries) | |||
| how can we hide the steps of macro running | Excel Discussion (Misc queries) | |||
| Hide the running macro | Excel Programming | |||
| Running a Excel Macro from Windows Scheduler | Excel Programming | |||
| How to hide all the actions while a macro is running | Excel Programming | |||
Hybrid Mode
