Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default Excel template-run code on open

I have an Excel template where I'm trying to run code when
the template is called via File-New-Select template. I
thought I could put code in the workbook "on open" but it
only runs when you actually open the template, rather than
basing a new file on it. Any ideas how I can do this -
run code when the template is used to create a new doc?

Thanks

Cindy
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
ON OPEN VBA Code input incorrectly now excel sheet wont open mmartin New Users to Excel 1 February 16th 11 11:33 PM
how do i get a template to open as the default excel file? skillmaster Excel Discussion (Misc queries) 3 April 28th 08 08:38 PM
Excel Template fails to open??? Rob Smith Excel Discussion (Misc queries) 2 April 11th 05 06:42 PM
excel template to open from network kurt Excel Programming 0 September 18th 03 12:42 PM
open excel workbook from template Nelson[_4_] Excel Programming 1 September 4th 03 11:55 PM


All times are GMT +1. The time now is 02:37 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"