How do I stop a message from appearing when deleting using VB?

[Silvertoe]

I am using the delete method in VB to delete a sheet that is being copied in
redundancy. How in the world do I stop Excels default message from appearing
and use my own?

 

[Don Guillett]

look in the help index for DISPLAY ALERTS

 

[Mike H]

Hi,

Application.DisplayAlerts = False
Worksheets("MySheet").Delete
Application.DisplayAlerts = True

Mike