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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top