View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Raj[_11_] Raj[_11_] is offline
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.....