Hi Norman and Niek -

Thanks for the clarification. When I run your respective test procedures,
my Watch Window does display the expected values for
Application.ScreenUpdating, but my QuickWatch always shows a value of True
(even when its value is False, as confirmed in the Watch Window). Also,
hovering the cursor over the ScreenUpdating term in the code always shows
"True". Do your QuickWatch dialogs behave similarly (always show
ScreenUpdating=True)?

Excel 2003/WinXP
--
Jay


"Norman Jones" wrote:

Hi Jay,

'----------------
The ScreenUpdating property always displays a value of true when you query
its value within the VB Editor. This and other application properties
(ScreenUpdating, EnableEvents, etc.) always show a True value even when
you've set them to False (I don't know why). The proof of whether it is
working is if screenupdating is suppressed when you want it to be.
'----------------
'=============
Public Sub TestIt()
Const sStr = "ScreenUpdating is on = "

With Application
.ScreenUpdating = False
MsgBox sStr & .ScreenUpdating
.ScreenUpdating = True
MsgBox sStr & .ScreenUpdating
End With
End Sub
'<<=============


---
Regards,
Norman