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?
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 Format>Cells>Protection and
unselect Locked.
Go to Tools>Protection>Protect 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" <[email protected]> wrote in message
news:[email protected]...
> 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 Format>Cells>Protection and
> unselect Locked.
> Go to Tools>Protection>Protect 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
news:[email protected]...
> 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 Format>Cells>Protection
and
> > unselect Locked.
> > Go to Tools>Protection>Protect 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" <[email protected]> wrote in message
> > news:[email protected]...
> > > 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" <[email protected]> wrote in message
news:[email protected]...
> 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 Format>Cells>Protection
>> and
>> unselect Locked.
>> Go to Tools>Protection>Protect 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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?
>>
>>
>>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks