Closing the save changes box
CrazySultana,
Try
Application.DisplayAlerts = False
just before the "save" in your code.
John
"CrazySultana" wrote in message
...
Hello :)
I have written a macro that opens up a file (1), changes a few things and
copies the data to an already open file.
The macro then proceeds to close file 1, and the save changes dialogue box
pops up. How can I make my code automatically select no or prevent that box
from popping up?
Thanks for any help
|