Confirm Delete Message Disable

R

RiosPapa

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 ?
 
A

Alan

Try,

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

Regards,
Alan
 
R

RiosPapa

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