Warning

[Dan]

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

 

[Guest]

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

 

[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")

.

 

[Tom Ogilvy]

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