Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro compiling screen
Some of the Macros in my program include maximising and minimising various
workbooks. Once the button with the assigned macro is clicked, the screen proceeds to show me all of the actions very quickly (as usual). What i would like to know is this, is there any way, or any code i could put in my macro so that a loading/compiling screen is shown to the user rather than the maximising/minimising of windows? Any help greatly apprectiated. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro compiling screen
On Jul 27, 2:18 pm, andrewbt
wrote: Some of the Macros in my program include maximising and minimising various workbooks. Once the button with the assigned macro is clicked, the screen proceeds to show me all of the actions very quickly (as usual). What i would like to know is this, is there any way, or any code i could put in my macro so that a loading/compiling screen is shown to the user rather than the maximising/minimising of windows? Any help greatly apprectiated. Thanks. Application.ScreenUpdating = False .... your main part of macro Application.ScreenUpdating = True Regarding putting a "loading/compiling screen", you should display a msgbox in the beginning of the macro. But I am not sure whether control flows pst when a msgbox is displayed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Screen tip | Excel Discussion (Misc queries) | |||
Macro as Screen Saver | Excel Discussion (Misc queries) | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Is this possible , screen captures with a macro? | Excel Worksheet Functions | |||
Macro suddenly causes the screen to blink | New Users to Excel |