Force a SaveAs

[Christa]

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.

 

[cush]

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.

 

[Chip Pearson]

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]

Thanks Chip. My typo.

Christas file should be something like
MyFile.xlt