Hi all:

I'm wondering if certain warning messages can be suppressed or kept from
displaying in the following situations:

1) I create a new worksheet, copy some data into it, then delete the
worksheet. When I execute the Delete statement, a warning comes up to
confirm the delete. I don't need the warning; the creation and copying and
deletion are all happening under the covers, so to speak, and the user
couldn't care less what I'm doing to "make the magic" happen.

2) When I'm saving a file and using the SaveAs command, if the file
already exists, I get a warning that it's going to overwrite it. If the old
one is overwritten, I don't care, and neither do my users. They're used to
seeing only the latest and greatest file in the directory. If they start to
see these warning messages, they're going to get cranky.

Any suggestions on ways to avoid these pesky popup prompts will be
greatly appreciated!

Thanks!

Jon

Application.DisplayAlerts = False
'delete**************
Application.DisplayAlerts = True

"JonWestcot" wrote:

> Hi all:
>
> I'm wondering if certain warning messages can be suppressed or kept from
> displaying in the following situations:
>
> 1) I create a new worksheet, copy some data into it, then delete the
> worksheet. When I execute the Delete statement, a warning comes up to
> confirm the delete. I don't need the warning; the creation and copying and
> deletion are all happening under the covers, so to speak, and the user
> couldn't care less what I'm doing to "make the magic" happen.
>
> 2) When I'm saving a file and using the SaveAs command, if the file
> already exists, I get a warning that it's going to overwrite it. If the old
> one is overwritten, I don't care, and neither do my users. They're used to
> seeing only the latest and greatest file in the directory. If they start to
> see these warning messages, they're going to get cranky.
>
> Any suggestions on ways to avoid these pesky popup prompts will be
> greatly appreciated!
>
> Thanks!
>
> Jon
>
>
>

Try

Application.DisplayAlerts = false

might help, fraid i can't check at the moment, excel is busy

Hi Mike:

Thanks! I looked through the Application object model but missed this
one. (Can't imagine how! It's not like there are very many methods and
properties from which to choose! <g>)

Jon

"Mike" <(E-Mail Removed)> wrote in message
news:464C3731-2E1C-4741-8F5E-(E-Mail Removed)...
> Application.DisplayAlerts = False
> 'delete**************
> Application.DisplayAlerts = True
>
> "JonWestcot" wrote:
>
> > Hi all:
> >
> > I'm wondering if certain warning messages can be suppressed or kept
from
> > displaying in the following situations:
> >
> > 1) I create a new worksheet, copy some data into it, then delete
the
> > worksheet. When I execute the Delete statement, a warning comes up to
> > confirm the delete. I don't need the warning; the creation and copying
and
> > deletion are all happening under the covers, so to speak, and the user
> > couldn't care less what I'm doing to "make the magic" happen.
> >
> > 2) When I'm saving a file and using the SaveAs command, if the file
> > already exists, I get a warning that it's going to overwrite it. If the
old
> > one is overwritten, I don't care, and neither do my users. They're used
to
> > seeing only the latest and greatest file in the directory. If they
start to
> > see these warning messages, they're going to get cranky.
> >
> > Any suggestions on ways to avoid these pesky popup prompts will be
> > greatly appreciated!
> >
> > Thanks!
> >
> > Jon
> >
> >
> >

Hi Keith:

Thanks -- you and Mike are on the same wavelength.

The info is much appreciated!

Jon


"Keith74" <(E-Mail Removed)> wrote in message
news:1f70f240-648c-4bef-8f29-(E-Mail Removed)...
> Try
>
> Application.DisplayAlerts = false
>
> might help, fraid i can't check at the moment, excel is busy