If you're really working with a template and a normal workbook, you could add a
line like:

if thisworkbook.path < "" then
exit sub
end if

If the workbook hasn't been saved, then there is not path--it must be a
template.

If you're not using a .xlt file -- just using a .xls and calling it a template,
then this won't work.

But you could use some other technique:

if lcase(thisworkbook.fullname) = lcase("whateverpath\filename.xls") then
'you're still looking at the "template"
end if



Troy wrote:

I have created an excel template with macros in Excel 2003. The template
works great. I am trying to figure out how to automatically disable the
macros after the initial open and save of the template. I tried to open the
xls file after I did a test run and the macros were still active. How can I
fix this?

--

Dave Peterson