disable Warning Message
 

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

disable Warning Message
 

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)

"larry" wrote in message
...
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