View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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.