ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Make safe Template (https://www.excelbanter.com/excel-discussion-misc-queries/63836-make-safe-template.html)

PJOS11

Make safe Template
 
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?

Ian

Make safe Template
 
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?




PJOS11

Make safe Template
 
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?





Ragdyer

Make safe Template
 
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?






Ian

Make safe Template
 
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?








All times are GMT +1. The time now is 12:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com