Macro to Save As for an Excel Macro Enabled workbook

[hvitzthum]

I am trying to write a save as macro that will allow my user to click a button on the worksheet and prompt a save as box to save the worksheet as Macro Enabled. What I have written so far allows me to save as a regular worksheet without the macro enabled. When I try to change the xlsx to slxm I get an error box that just says 400. Can someone tell me what I need to change to get that to go away? I copied the code from another post called "Macro to prompt save as - http://www.excelforum.com/excel-programming-vba-macros/947851-macro-to-prompt-to-save-as.html"

Please Login or Register  to view this content.

[ragulduy]

Assuming it's a type put it sould be xlsm not slxm as you mention in your post.

Anyway, untested because I'm a 2003 user but I believe it should be:

Please Login or Register  to view this content.