How can i automate the response to a generated pop up?

  • Thread starter Thread starter Eni001
  • Start date Start date
E

Eni001

I need VBA code that will select OK when the popup is generated in response
to a command to delete a worksheet.


Regards
 
You can turn off the pop up with the following line

Application.DisplayAlerts = False
 
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

Calling Crystal Ball Predictor from VBA 1
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Cell Toolbar Dilemma xl2013 13
Passing SQLPlus script location using Windows Script Host Object Model 11
Excel 2007 - Perplexing Undo VBA runtime error 1
Disabling Excel VBA Pop-ups... 4
Lenovo recalls 80,000 5th Gen ThinkPad X1 Carbon laptops 0
InputBox to name a range 2

Back
Top