Discussion Article

[ Home | Contents | Search | Reply | Previous | Next ]

Subject:
How to automatically respond to Yes/No messages?
Name:
John Reynen
Email (spam proof):
Email the originator of this post
Date:
Sunday, July 09, 2006
Hits:
69
Discussion (Terms and Conditions):
I am having trouble coming up with a command like to automatically respond to a "Yes/No" type message box that is generated from another add-in (not mine, and not one where I can access the code). I have tried "application.displayalerts = false", but this does not work as I suspect this is only useful for alerts generated by excel rather than those generated by an external add-in. My macro goes through sheets, one by one, updating information using the external add-in. At every page, I am prompted to reply "Yes" or "No" as to whether I want to display potential errors - I wish to ALWAYS, automatically, respond with a "No". I have also tried a number of different ways to try to say "if vbYesNo type message box, then please reply vbNo", but cant get anything to work! Any help would be really appreciated.

Sponsored by the best FTP application on the internet: