disable Warning Message

[larry]

I want to be able to delete a worksheet without getting
the built-in warning message every time on Excel 2000 SP2.
Is there a way to do this? Thanks

 

[Bob Phillips]

Application.DisplayAlerts = False

' your code

Application.DisplayAlerts = True

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)