Posted to microsoft.public.excel.worksheet.functions

Donna[_2_] Donna[_2_] is offline

external usenet poster

Posts: 76

Deleting worksheets in a macro

I have a macro that at the end there are 2 work sheets that I delete.
When the macro runs, it stops and asks if I really want to delete the
worksheets. Is there something I can add so that it will not ask me if I
want to delete?
Here is what I have.

Sheets("Sheet3").Select
ActiveWindow.SelectedSheets.Delete
Sheets("Sheet2").Select
ActiveWindow.SelectedSheets.Delete
Thanks Donna

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
Macro for Deleting Worksheets	andiam24	Excel Discussion (Misc queries)	2	April 2nd 09 03:47 PM
Deleting worksheets	David	Excel Discussion (Misc queries)	2	January 19th 07 08:19 PM
Deleting blank worksheets	Lvenom	Excel Worksheet Functions	3	June 15th 06 12:28 AM
Prompt before deleting worksheets?	cbrooks421	Excel Discussion (Misc queries)	2	July 20th 05 05:32 AM
Help deleting worksheets	Wilhelmutt	Excel Discussion (Misc queries)	2	April 19th 05 03:23 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us