To Save As macro-enabled template, use file extension "xltm" and file format 53, like so:


ActiveWorkbook.SaveAs Filename:="O:\Bellingham\Intranet\Production\Reports\Bagging Line Glaze Monitoring\" & Range("D11") & "_" & Range("D5") & "_" & Format(Now(), "YYYYMMDDhhmmss") & ".xltm", FileFormat:=53