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

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
.

Thank you!

Dan
-----Original Message-----
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
.

.

My guess is you are talking about

Application.DisplayAlerts = False

to put up a message at the bottom
Application.DisplayAlerts = True
msgbox "Done!"
End Sub

--
regards,
Tom Ogilvy


"Dan" wrote in 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