Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 40
Default Autorun macro on starting a template

Hi, using help from this forum, I've placed a macro in my workbook that runs
correctly when the workbook is opened. However, when I change the workbook
into a template (.xls to .xlt), the macro does not run. I think this must be
something very obvious!

Thanks,
Geoff.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Autorun macro on starting a template

A workbook_open event should fire if you do File=New and select you
template as the basis of the workbook.

If you are creating a new workbook or opening your template by running a
macro started with a key combination that includes the shift key, change the
combination so as not to include the shift key.
--
Regards,
Tom Ogilvy

"Geoff C" wrote in message
...
Hi, using help from this forum, I've placed a macro in my workbook that

runs
correctly when the workbook is opened. However, when I change the workbook
into a template (.xls to .xlt), the macro does not run. I think this must

be
something very obvious!

Thanks,
Geoff.



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
Autorun macro Josh Excel Discussion (Misc queries) 2 August 16th 09 02:19 PM
MACRO AUTORUN b52shut Excel Discussion (Misc queries) 1 December 15th 05 08:48 AM
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet wyndman Excel Programming 2 May 25th 04 06:59 PM
Autorun a macro Nigel Chapman Excel Programming 1 February 4th 04 01:02 PM
autorun macro hke[_3_] Excel Programming 6 October 16th 03 01:18 PM


All times are GMT +1. The time now is 07:59 AM.

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"