Thread: Warning
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 113
Default 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
.

.