VBA Issue Saving File With VBA, Formulas & Drop Down Lists

[TkdKidSnake]

Hi all,

I am have issues saving a workbook in a different location as a backup to the original however when using the code below I am finding that some of the detail is being lost.

Can anybody help with the code as I can see there are various settings that can be chosen.

ActiveWorkbook.SaveAs Filename:=Path & FileName1 & ".xlsm", FileFormat:=xlOpenXMLWorkbookMacroEnabled

Any help that you can provide would be greatly appreciated.


Thanks