Template with macro in Excel 2007

[Jirka]

Hello,
I have an Excel 2007 template with macro. When a user opens this document
and wants to save it, the default format is an Excel document without macro!
That's pitty.
However, when a user use a Sent document in a email, the format is correct.
That seems a bit schizophrenic for me.

I have SP1 for Office 2007 installed.

I don't want to change an Excel global settins to default format with macro.

So, how to enforce Excel 2007 to have default format document with macros
when my teplate with macro is opened.

Thanks

 

[Ron de Bruin]

Hi Jirka

I report this to MS a few months ago.
I hope they change this in the next version ?