Warning
 

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

Warning
 

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
.

Warning
 

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
.

.

Warning
 

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