disable Warning Message

L

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
 
B

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)
 
Top