How do I disable the popup that says Excel is "SAVING AS" with the bar that shows % complete? Application.DisplayAlerts = False doesn't seem to help.
Application.DisplayAlerts = False
ThisWorkbook.Save
txtdate = Format(Now, "mm") & "." & Format(Now, "dd") & "." & Format(Now, "yy")
ThisWorkbook.SaveAs Filename:="\\abc.com\Shares\Depts\Files\Reporting\Performance\Staffing_Bucket_" & txtdate & ".xlsx", FileFormat:=xlOpenXMLWorkbook
Application.Quit
Application.Quit
End Sub
Application.DisplayAlerts = False
ThisWorkbook.Save
txtdate = Format(Now, "mm") & "." & Format(Now, "dd") & "." & Format(Now, "yy")
ThisWorkbook.SaveAs Filename:="\\abc.com\Shares\Depts\Files\Reporting\Performance\Staffing_Bucket_" & txtdate & ".xlsx", FileFormat:=xlOpenXMLWorkbook
Application.Quit
Application.Quit
End Sub