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
|