Delete sheet without warning messages
 

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


---
Message posted from http://www.ExcelForum.com/

Delete sheet without warning messages
 

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


--
Message posted from http://www.ExcelForum.com