Macro compiling screen

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
Click to expand...


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.
 
Back
Top