Need help with cell protection...

  • 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.
 
Mark,

Please don't multipost to multiple groups.

The regulars here regularly read all the major Excel newsgroups.

The answer to your question is yes and no.
You can only have one password for a particular sheet.
The basics for password protecting cells is to select all
the cells and then choose Format/Cells/Protection
and then unlock all the cells. Then select the cells that you
want protected and unlock them.
Lastly, protect the sheet. Tools/Protection/Protect Sheet.

Now I replied in .programming because you can set these
protections programmatically via VBA and *IF* the users
are using different PC's to access the file (or unique UserNames),
then you could set the protection (and what cells are protected)
based on these.

Is that a possibility for your situation?

John
 
Mark

What version of Excel?

Excel 2002 alows for passworded permissions to ranges under Tools>Protection>
"Allow users to edit ranges"

Gord Dibben Excel MVP
 
Gord Dibben said:
Mark

What version of Excel?
Click to expand...

Office XP (WinXP Pro OS).
Excel 2002 allows for passworded permissions to ranges under Tools>Protection>
"Allow users to edit ranges"
Click to expand...

I tried that using the explanation on the MSDN site, but it didn't work.
 
Norman Harker said:
Hi Mark!

What you want to do can probably be achieved with a moderate degree of
difficulty.

But why not make it easier. Put the different ranges on different
sheets and protect those sheets with different passwords. If there are
reasons why you want the data to be together, then have a third sheet
that brings in the data from the separate sheets. All that and no
macros needed.

But worksheet protection is easily circumvented so this, like any
other solution, is not foolproof.


--
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.
Click to expand...

Thanks for the RE Norman! I worked it out using the "Allow users to edit
ranges" option. One password for each of the two user ranges and one for
the master. Works fine now. Thanks.
 
Mark

Two days ago when I suggested that, you posted "I tried that using the
explanation on the MSDN site, but it didn't work."

Guess you must have done a little more scratching, eh?

"Viable" solution was available, it seems.

Gord Dibben Excel MVP
 
Back
Top