View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Smith[_17_] John Smith[_17_] is offline
external usenet poster
 
Posts: 39
Default 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