Save Template as Macro-Enabled

Hello,

I am working with a file that is a macro-enabled template. I would like to request help with a macro that will do three things:

1. Save the template as a macro-enabled file.
2. Take the user to the Save As window of the directory F:\Billing Department\Share\Invoices\Setup\Commercial Customers. The user can then chose to save the file here or to any other subfolder from there.
3. Have as default “Setup Sheet” in the “File name” field of the Save As window. The user can then modify the field by adding any other text.

I would to attach this macro to a button.

I hope I explained this clearly enough. Thank you for any help!

Hi Marvin,

Thank you for the reply and for pointing this out to me.

The purpose of the macro is to make sure that when the user saves the template (.xltm), it is saved as a macro-enabled document as opposed to an .xls document. This way, when the user goes to modify the document again, they will still have other macros in the document available to them to use. Does this answer the question? I'm sorry, I perhaps should have explained this earlier.

Thank you, Marvin.

Just to clarify, I am looking for a macro that will save an .xltm file as an .xlsm (not .xlsx). I don't know that this changes your answer, but I just wanted to make sure we were on the same page.

I will glean through the links you provided. Thanks for researching and sending them on to me!