Multiple Users, One Excel Sheet

New_

New Member
Joined
Dec 7, 2012
Messages
3
Hey All,

I am looking to have an excel sheet that many users will have access too.
Is there anyway to lock information on the sheet after each person has put in their own data?

I know you can lock cells and then protect the sheet, but by doing this, those that enter information after the first can't re-lock the sheet.

So in summary. About 50 people will have access to the sheet and each will have to type information into one row. I want each person to be able to lock their own row after they have entered in the info. I don't want other people to be able to edit info that isn't their own so locking each row separately is vital.

Thanks.
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

fletcherj23

New Member
Joined
Nov 13, 2012
Messages
16
  1. If you are running Microsoft Office Excel 2007, click Allow Users to Edit Ranges on the Review menu in the Changes group.
  2. In the Allow Users to Edit Ranges dialog box, click New.
  3. In the New Range dialog box, click the Collapse Dialog button. Select the range B2:B6, and then click the Collapse Dialog button again.
  4. In the Range password box, type rangeone, then type it again in the Confirm Password dialog box, and then click OK.
  5. Repeat steps 3 through 5, selecting the range D2:D6 and typing rangetwo as the password for that range.
  6. 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.
  7. Select cell B3, and then start to type Dataone.

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

I'm assuming you are talking about something like this. Then just give the people a password for their cells.
 

New_

New Member
Joined
Dec 7, 2012
Messages
3
This is Awesome!
Is there a way I can re-lock the range after opening it?

  1. If you are running Microsoft Office Excel 2007, click Allow Users to Edit Ranges on the Review menu in the Changes group.
  2. In the Allow Users to Edit Ranges dialog box, click New.
  3. In the New Range dialog box, click the Collapse Dialog button. Select the range B2:B6, and then click the Collapse Dialog button again.
  4. In the Range password box, type rangeone, then type it again in the Confirm Password dialog box, and then click OK.
  5. Repeat steps 3 through 5, selecting the range D2:D6 and typing rangetwo as the password for that range.
  6. 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.
  7. Select cell B3, and then start to type Dataone.

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

I'm assuming you are talking about something like this. Then just give the people a password for their cells.
 

fletcherj23

New Member
Joined
Nov 13, 2012
Messages
16
As soon as they save their input and close it out for the next person, the cells are auto-password protected again, no need to re-lock them.
 

Forum statistics

Threads
1,136,260
Messages
5,674,682
Members
419,520
Latest member
Jennifer4Dillon

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
Top