Feb 25 2020 05:14 AM
Feb 25 2020 06:54 AM
@tim_p70f9 You need to supply the SaveAs method with the correct fileformat:
ThisWorkbook.SaveAs Filename:="FileName.xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled
Feb 26 2020 11:00 AM