Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Autorun macro | Excel Discussion (Misc queries) | |||
MACRO AUTORUN | Excel Discussion (Misc queries) | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming | |||
Autorun a macro | Excel Programming | |||
autorun macro | Excel Programming |