deleting worksheet

L

Laurent M

Hello,

i would like to know how i can delete a worksheet
automaticaly without confirming it in the dialog box.

Thanks.
 
B

Bob Phillips

You need VBA, and to set displayalerts off

Application.DisplayAlerts = False
Worksheets("Sheet1").Delete
APplication.DisplayAlerts = True

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top