I have a spreadsheet that is set up as a template. I want to be able to keep
the client from overwriting it. So every time the client uses it, I want to
force them to do a SaveAs and not be able to ever just Save the current file.

Have you actually saved this file as a true Template so that it has the
extention .xlb instead of .xls? If you have, then this should work
automatically for you: When the template is opened it is only a copy of the
original - with a number appended to the title. The user cannot change the
original with normal use.

"Christa" wrote:

I have a spreadsheet that is set up as a template. I want to be able to keep
the client from overwriting it. So every time the client uses it, I want to
force them to do a SaveAs and not be able to ever just Save the current file.

extention .xlb instead of .xls?

XLT not XLB. XLB is custom toolbars and settings.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)





"cush" wrote in message
...
Have you actually saved this file as a true Template so that it has the
extention .xlb instead of .xls? If you have, then this should work
automatically for you: When the template is opened it is only a copy of
the
original - with a number appended to the title. The user cannot change
the
original with normal use.

"Christa" wrote:

I have a spreadsheet that is set up as a template. I want to be able to
keep
the client from overwriting it. So every time the client uses it, I want
to
force them to do a SaveAs and not be able to ever just Save the current
file.

Thanks Chip. My typo.

Christas file should be something like
MyFile.xlt


"Chip Pearson" wrote:

extention .xlb instead of .xls?

XLT not XLB. XLB is custom toolbars and settings.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)





"cush" wrote in message
...
Have you actually saved this file as a true Template so that it has the
extention .xlb instead of .xls? If you have, then this should work
automatically for you: When the template is opened it is only a copy of
the
original - with a number appended to the title. The user cannot change
the
original with normal use.

"Christa" wrote:

I have a spreadsheet that is set up as a template. I want to be able to
keep
the client from overwriting it. So every time the client uses it, I want
to
force them to do a SaveAs and not be able to ever just Save the current
file.