Confirm Delete Message Disable

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

Guest

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
 
Yes this did the trick, thankyou for the timely and accurate support,
Have a great day
 
Back
Top