View original (French)

Hide the execution of a macro in Excel

Solved
emmanuel -  
 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

2 answers

  1.
    Armojax Posted messages 1863 Registration date   Status Member Last intervention   1 529
     
    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.
    95
    1. Sigma
       
      I love it, thank you so much.
      0
    2. Piertoo
       
      Thank you very much!
      0