How to protect cells?

  • Thread starter Thread starter Mark F.
  • Start date Start date
M

Mark F.

I would like to protect a range of cells (A2:D24) with a password for a
group of users that would make changes to cells in this range. Then on
the same sheet, also protect a range of cells (E2:E24) from everyone but
me. Is this possible?

Thanks.
 
John Wilson said:
Mark,

Please don't multipost.
See the thread in .programming.

John
Click to expand...

Generally it's considered bad netiquette to "cross-post" not multi-post.
I don't usually do that but I need help with this problem quickly.
 
I think you got that backwards.

I think most people would rather look at the header and see that it was
cross-posted (multiple groups at once).

Most(?) newsreader software will reply to all the groups so that work won't be
duplicated.

If you multipost (multiple posts with the same content posted multiple times),
there's no indication that others have worked on a response. It wastes time for
the (2nd thru xxth) responders.

And it means you have to check multiple spots for responses.
 
Mark,
Whatever
Click to expand...
Ya' know when people offer their help out of the goodness of their
hearts, "whatever" isn't an appropriate response.
I don't know if Dave (or the other MVP's) have a blacklist, but if they
do, I certainly wouldn't want to be on it.

The original intent of my post here and in .worksheet.functions was
to consolidate your multipost into just one thread in one ng.
The regulars read all three of the major ones anyway so it
really doesn't matter which one you post to.

Soooo...in summary....
You wasted your time posting to three different groups.
You wasted your time again by having to come back to
..worksheet.functions and complain that you "still don't
have a viable solution to your problem!"
Then you wasted your time having to come to this ng,
read the posts and insult Dave with your "Whatever"
Then you went to .programming to discover that Norman
had actually given you a "viable solution" to your problem.

I can almost guarantee that if you hadn't multiposted,
you'd have had your answer sooner (and wasted a lot less
of your time, my time and the others that read these ng's).

None of us work for MS and none of us get paid for
participating in these ng's. We do it because we enjoy
helping others. Keep that in mind the next time you post.

I'm glad you got an answer from Norman that worked for you.

John
 
Hi John!

I don't think any of the regulars keep a blacklist but if I'd seen the
"whatever" to Dave, I certainly would not have answered this post.
There might be a "whitelist" with grateful "customers" or those
struggling receiving endless patient help.

Whatever! I blame Jerry Springer.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
It may not have helped the OP, but I bet that there are lurkers who read these
messages. (I know I lurked before posting.)

And maybe it helped someone else who saw that fragmenting the responses doesn't
usually help the original poster.
 
Back
Top