Forced format choice when saving

[MattSilva7]

I am trying to force users to save as xlsm only, and found the following example:

http://mattiaslundstedt.com/force-sa...-macro-enabled

In the first reply it asks the same question I am stuck with... I want to use this as a template. He offers a partial answer, but even just attempting this without the template option which I dont understand... just forcing xlsm, I get a compile error: syntax error

[Richard Buttrey]

That macro appears to do all you want.

If the user tries to use the Save As option the filename type box defaults to .xlsm and only offers that. The user can't choose .xlsx or anything else for that matter.

[MattSilva7]

I think I see... its specifying SaveAs only? when I try to simply save I get the syntax error.

Just tried again and I get no error and no saved file.

Please Login or Register  to view this content.

I had to change it from xltm to xlsm to upload it. Code removed as well so I could save it. I'm not sure there is a better way to accomplish this.

[Richard Buttrey]

Here's a .xltm file

In order to save the original .xlsm file as a .xltm I needed to add a small procedure to save the file since the Before Save macro normally prevents saving as a different name. However the line of code

Please Login or Register  to view this content.

only prevents a user (that's the UI or User Interface bit) from saving as a different file type but code can save with a different type.

Apparently the forum doesn't allow .xltm files so I've uploaded a .zip file that contains the .xltm

[MattSilva7]

Ty, didnt think to simply zip it.

I am still seeing the last problem mentioned on my end. when I save I dont not get a saved file. when I try to close the file I get the option to save but still no saved file. When I do a SaveAs, I get nothing. no UI at all