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