How to acknowledge a message box from VB program?

  • Thread starter Thread starter Darwin
  • Start date Start date
D

Darwin

When deleting a sheet from VB program a message box pops
up and waits for acknowedgement. How can I
programmatically acknowledge (close) the box?
 
Application.DisplayAlerts = False
Sheet1.Delete
Application.DisplayAlerts = True
 
You must log in or register to reply here.

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

Similar Threads

Message box warns for duplicate use of named ranges when copying s 1
Excel Providing user message when RED X clicked & properly closing application. 2
How do I find what is in a spreadsheet 4
How do I stop a message from appearing when deleting using VB? 2
Error 400 in VB editor 3
Check a Check Box with VB 10
Saying No to Message Box prompt through VBA 6
Run file from VB in Excel 4

Back
Top