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
.
.
|