Thread: Confirm Delete Message Disable

When I delete a sheet which has data I get the standared confirmation dialog
allowing me to delete or cancel. This is a problem because I would like to do
this from a remote VB pgrogam.

Is there a way to disable this dialog ?

Try,

Application.DisplayAlerts = False
'Your code to do your thing
Application.DisplayAlerts = True

Regards,
Alan
"RiosPapa" <RiosPapa@discussions.microsoft.com> wrote in message
news:35D5C93D-5EEA-4EDD-9463-E2E845E01933@microsoft.com...
> When I delete a sheet which has data I get the standared confirmation
> dialog
> allowing me to delete or cancel. This is a problem because I would like to
> do
> this from a remote VB pgrogam.
>
> Is there a way to disable this dialog ?

Yes this did the trick, thankyou for the timely and accurate support,
Have a great day

"Alan" wrote:

> Try,
>
> Application.DisplayAlerts = False
> 'Your code to do your thing
> Application.DisplayAlerts = True
>
> Regards,
> Alan
> "RiosPapa" <RiosPapa@discussions.microsoft.com> wrote in message
> news:35D5C93D-5EEA-4EDD-9463-E2E845E01933@microsoft.com...
> > When I delete a sheet which has data I get the standared confirmation
> > dialog
> > allowing me to delete or cancel. This is a problem because I would like to
> > do
> > this from a remote VB pgrogam.
> >
> > Is there a way to disable this dialog ?
>
>
>