Password Protect 10 Rows With 10 Separate Passwords

johnboston

New Member
Joined
Mar 11, 2011
Messages
23
Is there a way to password protect 10 rows, each with its own separate password (i.e. 10 different passwords)?
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Try this

How to apply separate passwords


To apply different passwords to two ranges in a worksheet, follow these steps:
  1. Start Excel, and then open a blank worksheet.
  2. On the Tools menu, point to Protection, and then click Allow Users to Edit Ranges.

    Note If you are running Microsoft Office Excel 2007, click Allow Users to Edit Ranges on the Review menu in the Changes group.
  3. In the Allow Users to Edit Ranges dialog box, click New.
  4. In the New Range dialog box, click the Collapse Dialog button. Select the range B2:B6, and then click the Collapse Dialog button again.
  5. In the Range password box, type rangeone, then type it again in the Confirm Password dialog box, and then click OK.
  6. Repeat steps 3 through 5, selecting the range D2:D6 and typing rangetwo as the password for that range.
  7. In the Allow Users to Edit Ranges dialog box, click Protect sheet. In the Password to unprotect sheet box, type ranger, and then click OK two times. When prompted, retype the password.
  8. Select cell B3, and then start to type Dataone.

    Notice that as soon as you type D, the Unlock Range dialog box appears.
  9. Type rangeone in the Enter the password to change this cell box, and then press ENTER.

    You can now enter data in cell B3 as well as any other cell in the range B2:B6, but you cannot enter data in any of the cells D2:D6 without first providing the correct password for that range.
The range that you protect with a password does not have to consist of adjacent cells. If you want the ranges B2:B6 and D2:D6 to share a password, you can select B2:B6 as described in step 4 earlier in this article, type a comma in the New Range dialog box, and then select the range D2:D6 before you assign the password.


FROM link
 
Upvote 0
That was so easy I'm almost embarrassed. Thanks! Exactly what I was looking for. Thank you so much, again, pedie. John.
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top