Deleting Worksheet

  • Thread starter Thread starter shimeel
  • Start date Start date
S

shimeel

Hello..

When in a macro, i delete a worksheet, it pops up a message asking fo
confirmation to delete the worksheet.. is there any way i can stop tha
message from coming up and delete it ... ?


shimee
 
hi
Application.DisplayAlerts = False
Worksheets("yourworksheet").Delete
Application.DisplayAlerts = True

when you turn alerts off, be sure to turn them back on
again.
Regards
Frank
 
You must log in or register to reply here.

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

Counting Rows 1
ShowAllData 2
Macro Help 1
Deleting rows which contain blank cells 11
another macro query - deleting a worksheet within a query 2
Unhide macro worksheet 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Suppress worksheet delete verification msgbox 5

Back
Top