![]() |
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? |
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? |
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? |
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? |
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