turning off unwanted warnings

[Guest]

Occasionally I get messages/warnings during VBA/macro execution. E.g. a message that I have left a large amount of data asking if I want to save this data for other programs. These messages/warnings interrupt the VBA until I respond to them. Is there a way to turn off these types of messages

 

[Peter Atherton]

-----Original Message-----
Occasionally I get messages/warnings during VBA/macro

execution. E.g. a message that I have left a large amount
of data asking if I want to save this data for other
programs. These messages/warnings interrupt the VBA until
I respond to them. Is there a way to turn off these types
of messages?

Roland

Try

Application.displayAlerts = False
and On error resume next

Regards
Peter