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