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

Can't seem to delete all images from a Word Doc 2
Finding the right style field in VBA 0
Paste to excel from word - auto format problem 1
Improving Macro That Keeps First Letter 0
disable from deleting rows; folders not to delete; sheets to inser 2
Prevent a tab from edit, delete and copy 4
How do I stop chart dialogs from appearing 0
Delete from Registry using VBA 3

Top