I want my employees to be able to enter data into some cells in a worksheet
but the rest I want protected. I go to protection under tools and protect
the worksheet but can't figure out how to unlock the few I want accessible.
Glenn
I want my employees to be able to enter data into some cells in a worksheet
but the rest I want protected. I go to protection under tools and protect
the worksheet but can't figure out how to unlock the few I want accessible.
Glenn
first turn off worksheet protection (under tools)
then select cells you want to leave unprotected and format them as such
(format...cells....protection and uncheck the box)
then turn on worcksheet protection
not a professional, just trying to assist.....
I'd mark all of the cells ctrl-a, press ctrl-1 => protection => lock.
Then mark only those cells you'd want others to edit, and ctrl-1 =>
protection => unlock.
then you protect the sheet.
good luck
--
____________________
Peter Andersen
[email protected]
____________________
"Glenn Rowe" <[email protected]> skrev i en meddelelse
news:[email protected]...
>I want my employees to be able to enter data into some cells in a worksheet
> but the rest I want protected. I go to protection under tools and protect
> the worksheet but can't figure out how to unlock the few I want
> accessible.
> Glenn
>
>
THANKS, That was easy enough. Now how can I protect myself as the author
in properties but it still shows up.
Here is why I'm doing this. Interesting story! Ive been doing really helpful
spreedsheets for years and one person I just found has been sending them to
the big wigs with his name. I always wondered why they thought he was good
with Excel (he don't know jack) This will be soooo great.
"Peter Andersen" <[email protected]> wrote in message
news:[email protected]...
> I'd mark all of the cells ctrl-a, press ctrl-1 => protection => lock.
> Then mark only those cells you'd want others to edit, and ctrl-1 =>
> protection => unlock.
> then you protect the sheet.
>
> good luck
> --
> ____________________
>
> Peter Andersen
> [email protected]
> ____________________
>
>
> "Glenn Rowe" <[email protected]> skrev i en meddelelse
> news:[email protected]...
> >I want my employees to be able to enter data into some cells in a
worksheet
> > but the rest I want protected. I go to protection under tools and
protect
> > the worksheet but can't figure out how to unlock the few I want
> > accessible.
> > Glenn
> >
> >
>
>
Well, in a protected worksheet, it is sometimes helpful to know who made it,
in case you'd need to change something, or update rates, prices etc.
You could leave that information in a locked cell, as a service.
--
____________________
Peter Andersen
[email protected]
____________________
"Glenn Rowe" <[email protected]> skrev i en meddelelse
news:[email protected]...
> THANKS, That was easy enough. Now how can I protect myself as the author
> in properties but it still shows up.
> Here is why I'm doing this. Interesting story! Ive been doing really
> helpful
> spreedsheets for years and one person I just found has been sending them
> to
> the big wigs with his name. I always wondered why they thought he was good
> with Excel (he don't know jack) This will be soooo great.
>
> "Peter Andersen" <[email protected]> wrote in message
> news:[email protected]...
>> I'd mark all of the cells ctrl-a, press ctrl-1 => protection => lock.
>> Then mark only those cells you'd want others to edit, and ctrl-1 =>
>> protection => unlock.
>> then you protect the sheet.
>>
>> good luck
>> --
>> ____________________
>>
>> Peter Andersen
>> [email protected]
>> ____________________
>>
>>
>> "Glenn Rowe" <[email protected]> skrev i en meddelelse
>> news:[email protected]...
>> >I want my employees to be able to enter data into some cells in a
> worksheet
>> > but the rest I want protected. I go to protection under tools and
> protect
>> > the worksheet but can't figure out how to unlock the few I want
>> > accessible.
>> > Glenn
>> >
>> >
>>
>>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks