"Roger Govier" <roger@technology4unospamdotcodotuk wrote:

Hi Terry

You can only do it using a macro, where you set

Application.DisplayAlerts = False

run the rest of your code

Application.DisplayAlerts = True

The default is to be True, and you cannot just switch it off with a macro,
as it defaults back to True as soon as the macro ends.
Equally, trying to set it from the immediate window of the VB Editor will
not set it to false.

Thanks Roger. That's disappointing - I'd hoped there was a simple
user-setting in Options I'd missed! Seems a design flaw IMO.

--
Terry, East Grinstead, UK