View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
patrick molloy patrick molloy is offline
external usenet poster
 
Posts: 391
Default deleting sheet: how to omit warning

Application.DisplayAlerts = False

....will turn off such warnings

Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
Hello there,

when I call sheets(xyz).delete to delete a sheet from a

workbook I
get a warning at runtime asking if I am sure that I want

that sheet
deleted. (I wouldn't have coded it that way if I didn't

want it deleted :-))
My question: How do I omit this warning at runtime of my

vba script?

thanks
Marco

.