Excel template with VBA Code intact

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to Save as Template in 2007 Excel that will keep the VBA Code
and Macros in tact?
 
Yes. Save it as an "Excel Macro-Enabled Template" with a .xltm extension.

Best regards

John
 
John,
Thank you. I did not see that choice previously. I don't know how I missed
that.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

display message box in excel(2003) using VBA word(2003) 0
Tranfer data from Excel to word (Docx) via VBA in Excel 5
Excel 2007 erases VBA code from Excel 2003 5
Trouble Installing Excel VBA Code Cleaner into Office 365 0
Why do charts disappear? 2
using xltm as template 2
Proper VBA code to open Excel template 5
How to use templates with macros 1

Back
Top