How can I code it to delete a sheet without the warnings Thanks
N Nick Hodge May 10, 2005 #2 Nigel Sub QuietDelete With Application .DisplayAlerts = False Worksheets("Sheet1").Delete .DisplayAlerts = True End With End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England [email protected]
Nigel Sub QuietDelete With Application .DisplayAlerts = False Worksheets("Sheet1").Delete .DisplayAlerts = True End With End Sub -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England [email protected]
