LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default Delete Worksheets in same excel

Hi all,

I am deleting some sheets of my excel worrk book after doing
certain manipulations... I'm using the followin code to delete the
sheets...


Sheets(Array("Sheet 1", "Sheet 2").Select
ActiveWindow.SelectedSheets.Delete

but when this command gets executed it ask the excel message asking
for confirmation on deleting the sheets from the workbook... is there
any way that i can delete the sheets withou asking for the
confirmation to delete nstead delete at an instance.....

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
I can't delete my worksheets Dillon Excel Discussion (Misc queries) 1 March 5th 07 06:10 PM
SHOULDBE ABLE TO DELETE EXCEL WORKSHEETS EVEN IF NOT DOC CREATOR. le tamster Excel Worksheet Functions 5 September 9th 06 08:30 PM
How do I delete unwanted extra pages on Excel worksheets RogerD Excel Discussion (Misc queries) 4 May 20th 06 11:53 PM
Find & Delete Duplicates across two Excel Worksheets Lance[_4_] Excel Programming 12 October 14th 05 09:46 AM
How can I delete ALL text boxes in Excel worksheets? Genesis Excel Discussion (Misc queries) 3 January 20th 05 03:11 PM


All times are GMT +1. The time now is 06:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"