I'm trying to disable both DisplayAlerts and ScreenUpdating under XL97. In both cases I'm using the following syntax :
Application.DisplayAlerts = False
However the value always remains TRUE. I can modify it via the Immediate window without any problem.
I tried the following example on a clean workbook but the result was the same DisplayAlerts = True.
Private Sub CommandButton1_Click()
Dim rLocalrange As Range
Set rLocalrange = Range("A1")
Application.DisplayAlerts = Not Application.DisplayAlerts
rLocalrange.Value = Excel.Application.DisplayAlerts
I'm using Office97 SR1/ NT4 SP3. Any ideas what I'm doing wrong?