Without knowing which dialog you're referring to can't say for definite. However, I'd bet a pint that this will work:-
Application.DisplayAlerts=False
'Your code which causes the dialog
Application.DisplayAlerts=True
Excel automatically resets DisplayAlerts back to True anyway at the end of a procedure but it's good practice to do it anyway.
HTH,
D