• What is the best way to turn on and off screen updating and other applications to reduce interaction with code and screen.

    one way AutoDisplay routine below at the start and finish of synatx for code with more that one update

    Sub AutoDisplay()
    Application.ScreenUpdating = Not Application.ScreenUpdating
    Application.DisplayAlerts = Not Application.DisplayAlerts
    Application.Calculation = Array(xlCalculationManual, xlCalculationAutomatic)(CInt(Application.Calculation = xlCalculationAutomatic) + 1)
    End Sub
  • Application.ScreenUpdating doesn't need resetting now I believe

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!