Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to paste Word table into Excel 2003 intact? Mike M[_4_] Excel Discussion (Misc queries) 1 November 9th 07 09:45 PM
excel to word template code Markw911 Excel Programming 2 May 27th 07 03:06 AM
How do keep colors from a table in MS Excel intact when pasting? [email protected] Excel Discussion (Misc queries) 6 September 19th 06 07:44 PM
How to copy from Adobe with tables to Excel with columns intact Shengli Excel Discussion (Misc queries) 0 July 15th 06 06:56 AM
Excel template-run code on open Cindy Excel Programming 0 January 28th 04 04:19 PM


All times are GMT +1. The time now is 07:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"