Application.ScreenUpdating
Hi,
I'm using XL2007SP2 on WinXP and I'm having problems with the
following code:
Sub Turn_Off()
With Application
.EnableEvents = False
.ScreenUpdating = False
.Calculation = xlCalculationManual
End With
End Sub
When I run it, the screen updating stays set to true, while the other
two commands change condition. Can anyone tell what I need to do to
fix it?
Thanks.
James
|