About Us

Flystar[_17_]

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/

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

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help please - warning messages	adickson	Excel Worksheet Functions	1	May 23rd 09 02:05 PM
Warning Messages	fabio	Excel Worksheet Functions	3	October 15th 08 10:54 AM
How to prevent warning messages on protected work sheet.	Dannycol	Excel Worksheet Functions	3	April 5th 06 09:07 PM
What is the VBA code to delete a sheet without warning message?	[email protected]	Excel Discussion (Misc queries)	2	August 9th 05 04:16 PM
Getting rid of warning messages	Joel Wiseheart	Excel Programming	2	November 11th 03 08:32 PM

Menu

About Us