Annie,

Most dialogs can be supressed by setting the DisplayAlerts property to
false. When you do this, the dialog is not displayed. E.g.,

Application.DisplayAlerts = False
' your code here
Application.DisplayAlerts = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com



"Annie" wrote in message
...
I am new to VBA macro writing and cannot find a way of
automatically selecting the Yes option when a dialog box
is automatically displayed following an action e.g. after
deleting a worksheet. Could anyone help?

Many thanks, Annie