How to stop all Excel funtions for a period
Thnx a lot.
I used the following command to disable and enable it:
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
..... my code is here ....
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
|