Just add Application.DisplayAlerts = False to your code. Just make sure
you add Application.DisplayAlerts = True to the end of your code or you
won't get warnings for anything at all the rest of the time you're working
in Excel.