How can I suppress prompts during macro run?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Thanks a lot Bob!!

Bob Phillips said:
Precede the delete with

Application.Displayalerts = False

and reset to True afterwards

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
Click to expand...
 
Back
Top