How can I suppress prompts during macro run?

[Andorv]

I created a macro which in which I delete a sheet (tab). During the run I get
a prompt if I want to delete the sheet. How can I build in that I don't get a
prompt or that I can answer automatically? I have the same problem when
saving. I overwrite an existing file and I'm prompted if I want to overwrite,
which I want. How can I suppress these prompts or answer automatically?

Thank you for helping me out on this!!

Andor

 

[Bob Phillips]

Precede the delete with

Application.Displayalerts = False

and reset to True afterwards

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Andorv]

Thanks a lot Bob!!

Precede the delete with

Application.Displayalerts = False

and reset to True afterwards

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)