Dialog Box Confirmation Selection
 

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

Dialog Box Confirmation Selection
 

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