View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Nate Oliver[_4_] Nate Oliver[_4_] is offline
external usenet poster
 
Posts: 8
Default Auto delete of a sheet

Hello Wendell,

You're not the Leafs former power forward are you? Best wrist-shot
ever!

You'll want to toggle the Application's 'alerts' setting for this,
e.g.,

Sub foo()
Application.DisplayAlerts = False
On Error Resume Next ' In case it's not there
ThisWorkbook.Worksheets("Temp").Delete
On Error GoTo 0
Application.DisplayAlerts = True
End Sub

Regards,
Nate Oliver