Protect a Template?

I have an Excel2000 workbook on a shared drive; users fill out some cells in the excel file and are supposed to do a "save as" to save it as a separate file. The problem is that they will often save and overwrite my blank template. What is the best way to go about setting up a protected blank template that they can fill out, but then are forced to save as something different (i.e. they can't overwrite my master blank copy)? I've tried setting up the file as an ".xlt", but that didn't help. Any suggestions are appreciated. Thank you.

--
"The definition of insanity is doing the same thing over and over again and expecting a different result." - Albert Einstein

Hi
set this up as *.xlt file, place this file in the template path of your
computer.
Creating a new file based on this template would NOT overwrite the
existing one

--
Regards
Frank Kabel
Frankfurt, Germany

"Nico" schrieb im Newsbeitrag
...
I have an Excel2000 workbook on a shared drive; users fill out some
cells in the excel file and are supposed to do a "save as" to save it
as a separate file. The problem is that they will often save and
overwrite my blank template. What is the best way to go about setting
up a protected blank template that they can fill out, but then are
forced to save as something different (i.e. they can't overwrite my
master blank copy)? I've tried setting up the file as an ".xlt", but
that didn't help. Any suggestions are appreciated. Thank you.

--
"The definition of insanity is doing the same thing over and over
again and expecting a different result." - Albert Einstein

This old post should help.

http://tinyurl.com/3r5aj
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Nico" wrote in message
...
I have an Excel2000 workbook on a shared drive; users fill out some cells in
the excel file and are supposed to do a "save as" to save it as a separate
file. The problem is that they will often save and overwrite my blank
template. What is the best way to go about setting up a protected blank
template that they can fill out, but then are forced to save as something
different (i.e. they can't overwrite my master blank copy)? I've tried
setting up the file as an ".xlt", but that didn't help. Any suggestions are
appreciated. Thank you.

--
"The definition of insanity is doing the same thing over and over again and
expecting a different result." - Albert Einstein

I read in microsoft.public.excel.misc that =?Utf-8?B?Tmljbw==?=
wrote (in 71A22F8C-41BC-4A6F-
) about 'Protect a Template?', on Wed,
21 Jul 2004:
"The definition of insanity is doing the same thing over and over again
and expecting a different result." - Albert Einstein

Presumably he excluded playing dice and the like. And a number of other
human activities. Just imagine if it applied to ball games!
--
Regards, John Woodgate, OOO - Own Opinions Only.
The good news is that nothing is compulsory.
The bad news is that everything is prohibited.
http://www.jmwa.demon.co.uk Also see http://www.isce.org.uk

Sorry !

I should learn to read the post before answering.

The above link was for individual machines.

You're on a network, so try this link, which describes only *one* way to
establish a network template system.

If this doesn't seem to work for you, post back for some other procedures.

http://tinyurl.com/3ubkw
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"RagDyer" wrote in message
...
This old post should help.

http://tinyurl.com/3r5aj
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Nico" wrote in message
...
I have an Excel2000 workbook on a shared drive; users fill out some cells in
the excel file and are supposed to do a "save as" to save it as a separate
file. The problem is that they will often save and overwrite my blank
template. What is the best way to go about setting up a protected blank
template that they can fill out, but then are forced to save as something
different (i.e. they can't overwrite my master blank copy)? I've tried
setting up the file as an ".xlt", but that didn't help. Any suggestions are
appreciated. Thank you.

--
"The definition of insanity is doing the same thing over and over again and
expecting a different result." - Albert Einstein

Thank you for the links, I will read over them again, but I don't think going to each machine is a viable option since I will have over 50 users.

I'm starting to realize the problem may be with how I'm launching Excel. I'm launching from a command button in an MS Access2K database.

The problem is that when the button (launching this excel file) is clicked from MS Access then the original XLT template is opened and not a "book" copy ie (bookingform.xlt) and not (bookingform1.xls)

When I launch the file by double clicking the excel template it works correctly and the copy opens allowing you to input data and then save as an xls doc, not interfering with the original xlt template.

Any ideas?? Thanks again.



--
"The definition of insanity is doing the same thing over and over again and expecting a different result." - Albert Einstein


"RagDyer" wrote:

Sorry !

I should learn to read the post before answering.

The above link was for individual machines.

You're on a network, so try this link, which describes only *one* way to
establish a network template system.

If this doesn't seem to work for you, post back for some other procedures.

http://tinyurl.com/3ubkw
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"RagDyer" wrote in message
...
This old post should help.

http://tinyurl.com/3r5aj
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Nico" wrote in message
...
I have an Excel2000 workbook on a shared drive; users fill out some cells in
the excel file and are supposed to do a "save as" to save it as a separate
file. The problem is that they will often save and overwrite my blank
template. What is the best way to go about setting up a protected blank
template that they can fill out, but then are forced to save as something
different (i.e. they can't overwrite my master blank copy)? I've tried
setting up the file as an ".xlt", but that didn't help. Any suggestions are
appreciated. Thank you.

--
"The definition of insanity is doing the same thing over and over again and
expecting a different result." - Albert Einstein

I don't know anything about Access, but,
For a true networked template system in XL, *every* machine that you wish to
have access to the templates, *must* have the path to the template file on
their individual drives.

Older versions of XL allowed *true* templates to exist *anywhere* in the
system, as long as they had a .xlt extension.
From XL97 onwards, *true* templates were recognized by XL by where they were
stored, no matter what the file extension ... .xlt or even .xls.

There's no way around placing the path to the particular template folder on
*every* machine, though this only has to be done *once* at the outset.

Now, if there's something that exists in combination with Access, I'm not
aware of it.
It may pay to perhaps visit an Access group, and ask there if there might be
a procedure that doesn't require the path to be entered on each and every
machine.
--

Regards,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Nico" wrote in message
news Thank you for the links, I will read over them again, but I don't think
going to each machine is a viable option since I will have over 50 users.

I'm starting to realize the problem may be with how I'm launching Excel. I'm
launching from a command button in an MS Access2K database.

The problem is that when the button (launching this excel file) is clicked
from MS Access then the original XLT template is opened and not a "book"
copy ie (bookingform.xlt) and not (bookingform1.xls)

When I launch the file by double clicking the excel template it works
correctly and the copy opens allowing you to input data and then save as an
xls doc, not interfering with the original xlt template.

Any ideas?? Thanks again.



--
"The definition of insanity is doing the same thing over and over again and
expecting a different result." - Albert Einstein


"RagDyer" wrote:

Sorry !

I should learn to read the post before answering.

The above link was for individual machines.

You're on a network, so try this link, which describes only *one* way to
establish a network template system.

If this doesn't seem to work for you, post back for some other procedures.

http://tinyurl.com/3ubkw
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"RagDyer" wrote in message
...
This old post should help.

http://tinyurl.com/3r5aj
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Nico" wrote in message
...
I have an Excel2000 workbook on a shared drive; users fill out some cells
in
the excel file and are supposed to do a "save as" to save it as a separate
file. The problem is that they will often save and overwrite my blank
template. What is the best way to go about setting up a protected blank
template that they can fill out, but then are forced to save as something
different (i.e. they can't overwrite my master blank copy)? I've tried
setting up the file as an ".xlt", but that didn't help. Any suggestions
are
appreciated. Thank you.

--
"The definition of insanity is doing the same thing over and over again
and
expecting a different result." - Albert Einstein

I don't speak the Access, but this kind of thing worked ok for me from MSWord.

Maybe just have your button code use it???

Option Explicit
Sub testme()

Dim myXL As Object

Set myXL = Nothing
On Error Resume Next
Set myXL = GetObject(, "Excel.Application")
If Err.Number = 429 Then
Set myXL = CreateObject("Excel.Application")
End If
On Error GoTo 0

myXL.Visible = True

myXL.Workbooks.Add "\\sharename\foldername\templatename.xlt"

Set myXL = Nothing

End Sub

Nico wrote:

Thank you for the links, I will read over them again, but I don't think going to each machine is a viable option since I will have over 50 users.

I'm starting to realize the problem may be with how I'm launching Excel. I'm launching from a command button in an MS Access2K database.

The problem is that when the button (launching this excel file) is clicked from MS Access then the original XLT template is opened and not a "book" copy ie (bookingform.xlt) and not (bookingform1.xls)

When I launch the file by double clicking the excel template it works correctly and the copy opens allowing you to input data and then save as an xls doc, not interfering with the original xlt template.

Any ideas?? Thanks again.

--
"The definition of insanity is doing the same thing over and over again and expecting a different result." - Albert Einstein

"RagDyer" wrote:

Sorry !

I should learn to read the post before answering.

The above link was for individual machines.

You're on a network, so try this link, which describes only *one* way to
establish a network template system.

If this doesn't seem to work for you, post back for some other procedures.

http://tinyurl.com/3ubkw
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"RagDyer" wrote in message
...
This old post should help.

http://tinyurl.com/3r5aj
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Nico" wrote in message
...
I have an Excel2000 workbook on a shared drive; users fill out some cells in
the excel file and are supposed to do a "save as" to save it as a separate
file. The problem is that they will often save and overwrite my blank
template. What is the best way to go about setting up a protected blank
template that they can fill out, but then are forced to save as something
different (i.e. they can't overwrite my master blank copy)? I've tried
setting up the file as an ".xlt", but that didn't help. Any suggestions are
appreciated. Thank you.

--
"The definition of insanity is doing the same thing over and over again and
expecting a different result." - Albert Einstein



--

Dave Peterson

I don't think that I'd use the alternate file location.

MSOffice has a Workgroup templates location that excel can use--but excel can't
change.

If you open MSWord, you can do:
tools|options|file locations
and set that workgroup templates location to the network path you want.

You can also get to this if you use the MSOffice shortcut bar
Rightclick on an open spot|customize|settings tab


RagDyer wrote:

Sorry !

I should learn to read the post before answering.

The above link was for individual machines.

You're on a network, so try this link, which describes only *one* way to
establish a network template system.

If this doesn't seem to work for you, post back for some other procedures.

http://tinyurl.com/3ubkw
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"RagDyer" wrote in message
...
This old post should help.

http://tinyurl.com/3r5aj
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Nico" wrote in message
...
I have an Excel2000 workbook on a shared drive; users fill out some cells in
the excel file and are supposed to do a "save as" to save it as a separate
file. The problem is that they will often save and overwrite my blank
template. What is the best way to go about setting up a protected blank
template that they can fill out, but then are forced to save as something
different (i.e. they can't overwrite my master blank copy)? I've tried
setting up the file as an ".xlt", but that didn't help. Any suggestions are
appreciated. Thank you.

--
"The definition of insanity is doing the same thing over and over again and
expecting a different result." - Albert Einstein

--

Dave Peterson

Why do you suppose Dave, that any .xlt file placed there *doesn't* open
automatically with the XL session?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dave Peterson" wrote in message
...
I don't think that I'd use the alternate file location.

MSOffice has a Workgroup templates location that excel can use--but excel
can't
change.

If you open MSWord, you can do:
tools|options|file locations
and set that workgroup templates location to the network path you want.

You can also get to this if you use the MSOffice shortcut bar
Rightclick on an open spot|customize|settings tab


RagDyer wrote:

Sorry !

I should learn to read the post before answering.

The above link was for individual machines.

You're on a network, so try this link, which describes only *one* way to
establish a network template system.

If this doesn't seem to work for you, post back for some other
procedures.

http://tinyurl.com/3ubkw
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"RagDyer" wrote in message
...
This old post should help.

http://tinyurl.com/3r5aj
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Nico" wrote in message
...
I have an Excel2000 workbook on a shared drive; users fill out some
cells in
the excel file and are supposed to do a "save as" to save it as a
separate
file. The problem is that they will often save and overwrite my blank
template. What is the best way to go about setting up a protected blank
template that they can fill out, but then are forced to save as
something
different (i.e. they can't overwrite my master blank copy)? I've tried
setting up the file as an ".xlt", but that didn't help. Any suggestions
are
appreciated. Thank you.

--
"The definition of insanity is doing the same thing over and over again
and
expecting a different result." - Albert Einstein

--

Dave Peterson