Posted to microsoft.public.excel.programming

ivan

external usenet poster

Posts: 67

Delete worksheet without confirmation

Dear all,

I am using a macro to delete a worksheet of a workbook:

Sheets("mySheet").Select
ActiveWindow.SelectedSheets.Delete

However, it prompts me a dialog box for confirmation everytime. How to skip
this so that the sheet can be delete right away??
Thanks.

Ivan

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
A question about the confirmation	loveflying_best[_2_]	Excel Discussion (Misc queries)	1	October 8th 07 12:42 PM
How to avoid delete confirmation	Jens Palacios Neffke[_2_]	Excel Discussion (Misc queries)	1	August 1st 07 01:06 AM
Getting rid of confirmation boxes	DandruffKid	New Users to Excel	2	March 28th 05 11:05 AM
Confirmation of file	phil	Excel Programming	2	January 22nd 05 02:27 AM
Saving an Excel worksheet without getting the confirmation box	Mike	Excel Programming	1	January 13th 04 04:07 PM

All times are GMT +1. The time now is 10:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us