View original (French)

Private Sub Workbook_Open() Application.ScreenUpdating = False End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.ScreenUpdating = True End Sub

Solved
printfx000 -  
 printfx000 -
Hello,

I have an Excel macro that takes a certain amount of time to execute. As a result, we can see sheets, cells, and Excel files scrolling on the screen for about 5 minutes.

Is there a way to suspend this in order to allow the execution of the macro to be faster?

Thank you.

Configuration: Windows XP / Internet Explorer 7.0

2 answers

  1.
    f894009 Posted messages 17417 Registration date   Status Member Last intervention   1 717
     
    Hello,

    'put at the beginning of the macro
    Application.ScreenUpdating = False
    'put at the end of the macro before the end sub
    Application.ScreenUpdating = True

    have a good continuation
    1
  2. printfx000
     
    Thank you very much. It's perfect.
    0