View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default deleting sheet: how to omit warning

Don't forget to turn it back on again at the end!
-----Original Message-----
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

.

.