Preventing macro from .xlt from executing in a .xls

[XxLicherxX]

Hello everyone,

I am new to this, so hopefully this isn't too stupid of a question.

I have a created a .xlt with some macros in it. A user double clicks on
this .xlt file, some macros run, the user makes the necessary changes
to the file and saves it as a .xls. When the user saves it, some more
macros run.

Now when the user opens or saves the .xls file, the same macros will
run again, however, I don't want them to run again. What can I do to
stop these macros from executing in the .xls files?

Thanks

Dave

 

[Ron de Bruin]

Hi

You can test the ThisWorkbook path
A template have no path

Sub test()
If Len(ThisWorkbook.Path) = 0 Then
MsgBox "run the code it is a template"
Else
MsgBox "The file is a xls"
End If
End Sub

 

[XxLicherxX]

Thanks

That worked for me.