Delete sheet without warning messages

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....)
 
C

chris

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....
 
Top