Application.DisplayAlerts = False showing True

Hi All,

I have

Application.DisplayAlerts = False

'My code here

Application.DisplayAlerts = True

However when I hold the cursor over the "False" line in the code the tooltip equates to "True".

If I add

Debug.Print Application.DisplayAlerts

the Immediate window shows "False"

Why should this be?

My reason for asking is that I have broken my code up into several separate Subs like

Sub Total()
Application.DisplayAlerts = False
Call Headers
Call Find
Call Format
Call Copy
Sheets("Unformatted").Delete
Application.DisplayAlerts = True
End Sub

and the prompt window always asks if I'm sure I want to delete that sheet?


Regards

Seamus

This works fine for me, no warning message about deleting the sheet. You don't turn the DisplayAlerts on again in one of the Procedures do you?

Option Explicit

Sub delSht()
    Sheet1.Delete
End Sub
Sub test()
    MsgBox "X"
End Sub
Sub main()
    Application.DisplayAlerts = False
    test
    delSht
    Application.DisplayAlerts = True
End Sub