Hide the execution of a macro in Excel
Solved
emmanuel
-
munnuhutu -
munnuhutu -
Hello,
I am working on a laptop running Windows XP. I created a project in Excel with some macros made from the menu.
The execution of a macro switching from one sheet to another is quite unpleasant to watch on the screen. How can I hide this process?
Thank you for your responses.
Emmanuel
I am working on a laptop running Windows XP. I created a project in Excel with some macros made from the menu.
The execution of a macro switching from one sheet to another is quite unpleasant to watch on the screen. How can I hide this process?
Thank you for your responses.
Emmanuel
2 réponses
Hello Emmanuel,
Without any specific details, your macro, when running, shows everything it does: selections, sheet activations, etc...
To avoid this display, you need to disable screen updating at the beginning of the macro using the command:
Application.ScreenUpdating = False
and reactivate it at the end of the macro:
Application.ScreenUpdating = True
Thus, the macro runs much faster. During execution, the hourglass appears if it takes long enough.
Ajx.
Without any specific details, your macro, when running, shows everything it does: selections, sheet activations, etc...
To avoid this display, you need to disable screen updating at the beginning of the macro using the command:
Application.ScreenUpdating = False
and reactivate it at the end of the macro:
Application.ScreenUpdating = True
Thus, the macro runs much faster. During execution, the hourglass appears if it takes long enough.
Ajx.
Sigma
I love it, thank you so much.
Piertoo
Thank you very much!