How do I run macros upon opening only if it is not the template?

D

davis6206

I currently have a Private Sub that is supposed to run on Workbook_Open. It
runs macros when I open that particular workbook. However, that workbook is
a template. I don't want the macros to run when I'm opening the template. I
only want them to run if I'm creating a new workbook using that template.
How do I tell it to run the macros depending on whether I'm opening the
template or creating a new workbook using the template?
 
O

Office_Novice

Try putting the code in Workbook_New rather then _open. This should solve
your problem
 

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

Prompt User to Select Macro to Run? 1
How to use templates with macros 1
Template Functionality 3
Excel 2007: Macros not working in password-protected workbooks 2
Open workbook from code without running macros 2
template macro executing problem the 2nd time 1
Computer freezes when user clicks "enable" macros 3
Passing info to the Workbook.Open event 5

Top