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

  • Thread starter Thread starter Silvertoe
  • Start date Start date
S

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?
 
Hi,

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

Mike
 
Back
Top