Reading your message made me remember where I left off on another project where I had the same "problem", but never added that "check" feature.
I guess you'd be able to have the macro test to see if it is asked to run in the one workbook where it is supposed to by checking the workbook's name and if the name is not matching with your criteria, exit the macro, otherwise perform the task on hand.
There maybe a different way to to this. My beginners brain would do this. ;-) And then again, i never played with Templates either.
Code:Sub Test() If ThisWorkbook.Name = "test1.xls" Then MsgBox "Workbook name confirmed" ' Your code Else: MsgBox "Workbook name not confirmed" Exit Sub End If End Sub