CODEWITHSUNDEEP
excelsave
jslice25
jslice25

Reputation: 17

How to Change Default Save in Excel to .xlsm type

I have to save a bunch of .xls or text delimited files as .xlsm files so macros can be saved in the file and used in the future. I couldn't find a default file save format in options, so is there a way to set Excel to automatically save as .xlsm?

Excel 2013

Upvotes: 1

Views: 611

Answers (1)

VinnyGuitara
VinnyGuitara

Reputation: 605

Excel 2010: File --> Options --> Save --> Set the type you want.

You should revise your question to add the version of Excel you are on.

Screen Shot -- Look Here

Upvotes: 2

Related Questions