View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff[_5_] Harald Staff[_5_] is offline
external usenet poster
 
Posts: 47
Default Automatic response to message box?

No. (Yes, ok, with SendKeys, but that is extremely unreliable.) The trick is
to make the boxes NOT appear at all. That's done with

Application.DisplayAlerts = False

But then you'd better make sure your code knows what it does, like close
without saving changes, overwriteexisting file, things like that.

--
HTH. Best wishes Harald
Excel MVP
Followup to newsgroup only please

"Benjamin" skrev i melding
...
If every time I run a macro I get a typical message box,
can I program it to automatically respond to it?

For example, if within my macro I close a file and it asks
me if I want to save the changes, can my macro
automatically respond to the message box saying NO?