View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jake Marx[_3_] Jake Marx[_3_] is offline
external usenet poster
 
Posts: 860
Default Force Delete a Sheet

Hi Michael,

To supress the messagebox(es), you can use the DisplayAlerts property:

Application.DisplayAlerts=False
'/ delete sheet here
Application.DisplayAlerts=True

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Michael Kintner wrote:
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