I have a workbook that the on open event opens a form. This works great. This form is only needed the first time the workbook is opened. I have a macro that runs the following save as code
Sub Macro2()
Dim newFile As String, fName As String
fName = Range("M1").Value
newFile = Format$(Date + 1, "mm-dd-yyyy") & fName
ChDir _
"H:\Spreadsheets\Unit Reports\"
ActiveWorkbook.SaveAs Filename:=newFile
End Sub
This saves the workbook just like I want. The issue is on the "new" workbook I do not want the form to open, on open (it is not needed) I tried this code at the end of my save as event trying to disable the On Open Event. Did not work.
any ideas?
Application.EnableEvents = False
Bookmarks