unprotecting selected cells

  • Thread starter Thread starter Glenn Rowe
  • Start date Start date
G

Glenn Rowe

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'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
(e-mail address removed)
____________________
 
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.
 
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
(e-mail address removed)
____________________
 
Back
Top