View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tijmen Tijmen is offline
external usenet poster
 
Posts: 3
Default avoid warning when removing sheet

I want to remove all sheets except of sheet 1 by a macro

iSheetMax = Sheets.Count

' Delete other sheets
For iSheet = 2 To iSheetMax
Sheets(2 + iSheetMax - iSheet).Delete
Next

Then the user gets a warning message (warns for permanently deleting of
sheet).
I do not want this.

How can I prevent the warning message to appear?

Thanks,

Tijmen