Macro help anyone.....
Sub yourMacro()
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs Filename:="C:\myDir\myBook.xls"
' rest of code
Application.DisplayAlerts = True
End Sub
--
HTH
RP
(remove nothere from the email address if mailing direct)
"John O'Boyle" wrote in message
...
Do you have an example of how that statement is contructed and where
that statement should go? Do I just add it to my (edited) existing macro?
thanks.
J.
Bob Phillips wrote:
Try setting Application.DisplayAlerts = False before this code, it will
then
just continue. Reset afterwards.
|