Saving in .xlsm format by default

[PatrickS]

Is there any way to force excel 2007 to save in .xlsm format by default? At
the moment it seems to always try and save in .xlsx format by default
regardless of whether there are macros in the workbook or not. This seems a
little odd. Why can't excel choose .xlsm instead when macros are present so
that stuff isn't lost when you save?

In any case is there any way of changing the default file format in excel
2007? I'm assuming that the user would normally have to do something, but we
regularly send out spreadsheets with macros in it, and Excel 2007 users
equally have problems when they inevitably save it in .xlsx format.

 

[Orion Cochrane]

Go to the Office Button > Excel Options > Save. Select the Macro-Enabled
Workbook format on the default drop-down.

 

[Howard31]

Thanks Orion Cochrane,

Although I didn't post the question, I was wondering the same thing.

 

[Gord Dibben]

Why can't excel choose .xlsm instead when macros are present so

that stuff isn't lost when you save?

I would suggest Excel has no idea what a new unsaved workbook contains.


Gord Dibben MS Excel MVP

 

[Ron de Bruin]

I would suggest Excel has no idea what a new unsaved workbook contains.

There is a way to test it in 2007 Gord
This is new in 2007 HasVBProject

See how I use it here
http://www.rondebruin.nl/saveas.htm

Case 52:
If .HasVBProject Then
FileExtStr = ".xlsm": FileFormatNum = 52
Else
FileExtStr = ".xlsx": FileFormatNum = 51
End If

 

[Gord Dibben]

Cool!

I finally installed 2007 on the weekend but will be a while until up to
speed with these sorts of things.


Gord

 

[Ron de Bruin]

I finally installed 2007 on the weekend

Great Gord, good to hear.

Have fun