Autorun macro on starting a template

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

Guest

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.
 
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.
 
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

Run a macro if file is a template 7
Run-time error ‘13’ mismatch type 1
using xltm as template 2
Once-only Macro 2
Copy & Paste from One Workbook to a Macroed Template Workbook 1
Unwanted workbooks on startup 2
Stopping a macro to edit the template then re-saving the macro for use 4
How do I run macros upon opening only if it is not the template? 1

Back
Top