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

Precede the delete with

Application.Displayalerts = False

and reset to True afterwards

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Andorv" wrote in message
...
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

Thanks a lot Bob!!

"Bob Phillips" wrote:

Precede the delete with

Application.Displayalerts = False

and reset to True afterwards

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Andorv" wrote in message
...
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