ExcelBanter - Macro-Enabled saving

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Macro-Enabled saving (https://www.excelbanter.com/excel-discussion-misc-queries/252333-macro-enabled-saving.html)

MReed

Macro-Enabled saving

Is there a way to have 2007 default to save all files as XLSM? Basically all
files I have need to be macro-enabled.

Jan Karel Pieterse

Macro-Enabled saving

Hi MReed,

Is there a way to have 2007 default to save all files as XLSM? Basically all
files I have need to be macro-enabled.

Office button, Excel options, save tab, "Save files in this format"

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com

All times are GMT +1. The time now is 08:12 PM.