ExcelBanter - Excel template with VBA Code intact

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Excel template with VBA Code intact (https://www.excelbanter.com/excel-programming/391924-excel-template-vba-code-intact.html)

P T Pi

Excel template with VBA Code intact

Is there a way to Save as Template in 2007 Excel that will keep the VBA Code
and Macros in tact?

John[_131_]

Excel template with VBA Code intact

Yes. Save it as an "Excel Macro-Enabled Template" with a .xltm extension.

Best regards

John

"P T Pi" wrote in message
...
Is there a way to Save as Template in 2007 Excel that will keep the VBA
Code
and Macros in tact?

P T Pi

Excel template with VBA Code intact

John,
Thank you. I did not see that choice previously. I don't know how I missed
that.

"John" wrote:

Yes. Save it as an "Excel Macro-Enabled Template" with a .xltm extension.

Best regards

John

"P T Pi" wrote in message
...
Is there a way to Save as Template in 2007 Excel that will keep the VBA
Code
and Macros in tact?

All times are GMT +1. The time now is 05:14 PM.