Hello. I have a template that I populate from another workbook using
formulas. As any template, when you double click the template it renames it
appends a 1 to the end of the filename and treats it as a .xls file. I need
code that will change all formulas to values and need to know where this code
goes in the template so that the forumlas in my template don't get
overwritten with values. I also need to know how to save this file with just
the values and no code behind.

Hope someone can help.

Cathy