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

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?
 
M

Mike H

Hi,

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

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

File Download - Security Warning 5
disable from deleting rows; folders not to delete; sheets to inser 1
Prevent a tab from edit, delete and copy 4
prevent warning message from appearing 1
Stop "save changes" message appearing 2
Pasting formats in without conditional formatting? 2
Suppressing an excel message 2
how do i stop the email icon appearing 5

Top