I have workbook with the VBA code below that saves a copy to a different folder. I discovered that the Copy also has this code in it.
Is there a way to Save a Copy so the Copy doesn't retain this VBA Code? I only want the Master File to have the Save a Copy command.
ActiveWorkbook.SaveAs Filename:= _
"W:\Everyone\Template\Set-up Form.xlsm", FileFormat _
:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
End Sub
Thank you for the help.
Is there a way to Save a Copy so the Copy doesn't retain this VBA Code? I only want the Master File to have the Save a Copy command.
ActiveWorkbook.SaveAs Filename:= _
"W:\Everyone\Template\Set-up Form.xlsm", FileFormat _
:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
End Sub
Thank you for the help.