Save .xlsm file as .xlsx used to work but now gives 1004 error

[unleashed7]

Hello, it's my first time here!

I'm stuck on this problem, as they updated Excel recently and can't force save file as default xlsm while it was working before for years.

ActiveWorkbook.SaveAs "foo", 51

This throws a 1004 error because "VB projects and XLM Sheets cannot be saved in a macro-free workbook".
Disabling alerts also doesn't help, as this is a Run-time error not an alert.

Funny thing is it almost seems like a bug, as if I try to save the file after this error as .xlsx manually the "Save" button literally does nothing, no warning or anything, just doesn't work. I can only save as an xlsm, and if I do save it like that, close excel then REOPEN this saved fuke, suddenly the Save button works for xlsm and asks me if I want to "Save and erase features" which I do.

Is there any way to solve this?

 

[Logit]

That didn't work unfortunately.

Regarding my post #2, did you edit the path to match your computer ? The path shown in my post is for my computer and would not function on yours.+

I am responding late on this because the macro works fine here on my machine.

Comments ?

 

[MARK858]

Comments ?

The OP's code in the first post should work now as MS have reverted back to the original dialog box now (at least on all the versions I have used recently)