Delete sheet without warning messages

  • Thread starter Thread starter Flystar
  • Start date Start date
F

Flystar

I have a macro that creates a temporary sheet. Once the macro is
finished I want to delete the temporary sheet. Is there a way to
disable/turn off the deleting worksheet warning msgbox? (the selected
sheet(s) will be permanately deleted....)
 
Application.DisplayAlerts = Fals
Sheets("MySheet").Delet
Application.DisplayAlerts = Tru

----- Flystar > wrote: ----

I have a macro that creates a temporary sheet. Once the macro i
finished I want to delete the temporary sheet. Is there a way t
disable/turn off the deleting worksheet warning msgbox? (the selecte
sheet(s) will be permanately deleted....
 
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

Delete Hidden Sheets 3
Delete Worksheets 4
Delete Sheet without Warning 5
clear all sheets code 4
Deleting a sheet with VBA 2
Disable Worksheet Delete Warning 1
Deleting a sheet during macro 1
Prevent user from Inserting new worksheet 4

Back
Top