View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MoiraGunn MoiraGunn is offline
external usenet poster
 
Posts: 2
Default macro to delete a sheet

I know this is an easy one but I need some help.
I'd like to delete a sheet in my macro but I keep getting a dialog box that
asks me if I'm sure I want to delete the sheet. I want to bypass this
automatically but don't know how. Any help is appreciated.
Example of the 2 lines I'm stuck on.

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

I'm using Excel 97.

Thanks Kathy