hi,
Application.DisplayAlerts = False
all code goes here
Application.DisplayAlerts = True 'don't forget to turn
'them back on again
msgbox("macro complete")

-----Original Message-----
Hi:

What is line of code, at the beginning of a macro to turn
off the warnings; and waht is the line at the end to
display a meesage as complete?

Thanks,

Dan
.