View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default Force Delete a Sheet

Michael,

Use something like

Application.DisplayAlerts = False
' delete the sheet
Application.DisplayAlerts = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Michael Kintner" wrote in message
...
How can I force Delete a Sheet without having a popup dialog?

I am currently doing this (ActiveWindow.SelectedSheets.Delete)

Is there anyother way?

Thank you in advance for your help...

Mike