Deleting Excel Message/Dialog Boxes

  • Thread starter Thread starter Michael J. Malinsky
  • Start date Start date
M

Michael J. Malinsky

Putting the following line of code near the top of your module will stop all
warning boxes from appearing:

Application.DisplayAlerts=False

Then at the end, place:

Application.DisplayAlerts=True

HTH
Mike
 
Hi,

I am writing a VB macro for Excel 2000 and a step in it
deletes a worksheet in the file. When macro runs during
this step a dialog or message box appears stating
that 'Selected Sheet will be permanently deleted, OK,
Cancel.' If user selects 'OK' the macro continues but if
they hit 'Cancel' the macro fails.

Does anyone know of if it is possible to write a code so
that this dialog box does not appear? Or any other way
to bypass it?

Thanks for any assistance/advise
 
Hi Rob

Application.DisplayAlerts = False
Activesheet.Delete
Application.DisplayAlerts = True
 
Hi
try the following
sub foo()
.....
application.DisplayAlerts = False
'your code to delete something
application.DisplayAlerts = True

....
end sub
 
Back
Top