Posted to microsoft.public.excel.programming

Mike

external usenet poster

Posts: 3,101

VBA for deleting a sheet

I am using the following code to delete a sheet within Excel:

ActiveWindow.SelectedSheets.Delete

Problem is, it is prompting the user to see if it is okay to delete. In
every scenario of this macro, it will be okay to delete, so how can I bypass
this message?

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
Deleting a sheet	Kjeldc	Excel Programming	1	August 9th 05 02:25 PM
Deleting sheet	Brandi[_2_]	Excel Programming	2	October 7th 04 09:31 PM
Deleting a sheet	P. Dileepan[_2_]	Excel Programming	3	April 12th 04 10:34 AM
Deleting Sheet	Tommi[_2_]	Excel Programming	3	December 18th 03 05:28 PM
Deleting a Sheet	Abdul Salam	Excel Programming	1	July 29th 03 12:43 AM

All times are GMT +1. The time now is 02:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us