macro between 2003 and 2007

  • Thread starter Thread starter Debbie Horner
  • Start date Start date
D

Debbie Horner

I have a macro which creates a file using a template. If Excel 2007 is the
default of the person opening the new instance, it gives the message that it
is opening without macros enabled in 2007...how do I change the code to
create a 2003 xls or a 2007 xlsm?

Thanks
 
If I understand you correct ?

I think if you change the default save format to xlsm in 2007 it is working correct

Office Button>Excel Options
Click on Save
It is the first option
 
Back
Top