How do I lock protect my template after setting it up. I still want to go
back and fill out information without the risk of disturbing the preset
template works?

Select the cells you want to change and got to FormatCellsProtection and
unselect Locked.
Go to ToolsProtectionProtect sheet and enter a password if you want, or
just lcick OK.
Savethe template.

Only the cells you unlocked can be changed unless the sheet is unprotected
again.

--
Ian
--
"PJOS11" wrote in message
...
How do I lock protect my template after setting it up. I still want to go
back and fill out information without the risk of disturbing the preset
template works?

Once I unprotect the sheet its is possible to alter the previous work. I want
to be able to protect this work but still be able to type details around this
work. I hope I am making sense.
Paul

"Ian" wrote:

Select the cells you want to change and got to FormatCellsProtection and
unselect Locked.
Go to ToolsProtectionProtect sheet and enter a password if you want, or
just lcick OK.
Savethe template.

Only the cells you unlocked can be changed unless the sheet is unprotected
again.

--
Ian
--
"PJOS11" wrote in message
...
How do I lock protect my template after setting it up. I still want to go
back and fill out information without the risk of disturbing the preset
template works?

See if this link to an old post helps:

http://tinyurl.com/83g2m

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"PJOS11" wrote in message
...
Once I unprotect the sheet its is possible to alter the previous work. I
want
to be able to protect this work but still be able to type details around
this
work. I hope I am making sense.
Paul

"Ian" wrote:

Select the cells you want to change and got to FormatCellsProtection
and
unselect Locked.
Go to ToolsProtectionProtect sheet and enter a password if you want,
or
just lcick OK.
Savethe template.

Only the cells you unlocked can be changed unless the sheet is
unprotected
again.

--
Ian
--
"PJOS11" wrote in message
...
How do I lock protect my template after setting it up. I still want to
go
back and fill out information without the risk of disturbing the
preset
template works?

It sounds like you're referring to a file rather than a template. You could
still use the method I mentioned, but with a file. You would need to
unprotect the sheet and lock the cells you have just entered data in, before
reprotecting the sheet and saving. It's hassle, but workable.

Another alternative may be to write some code to find and protect all cells
with data in them just before saving the file.

--
Ian
--
"PJOS11" wrote in message
...
Once I unprotect the sheet its is possible to alter the previous work. I
want
to be able to protect this work but still be able to type details around
this
work. I hope I am making sense.
Paul

"Ian" wrote:

Select the cells you want to change and got to FormatCellsProtection
and
unselect Locked.
Go to ToolsProtectionProtect sheet and enter a password if you want, or
just lcick OK.
Savethe template.

Only the cells you unlocked can be changed unless the sheet is
unprotected
again.

--
Ian
--
"PJOS11" wrote in message
...
How do I lock protect my template after setting it up. I still want to
go
back and fill out information without the risk of disturbing the preset
template works?