Thread: How do I stop a message from appearing when deleting using VB?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default How do I stop a message from appearing when deleting using VB?
Hi,

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

Mike

"Silvertoe" wrote:

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?
Reply With QuoteReply With Quote