Allow user edit

Question

I am working on a rostering spread sheet that allows individuals to select their own shifts for the coming month.  This is a drop down menu cell that each person selects their preferred option.

I have had people mistakenly change someone else's selection on the row above or below.  What I want is to specify the user id to amend the row and to have a manager password to amend as necessary too.  I have tried with 'Allow user edit' in review tab but this does not seem to work for drop down menus.  What can I do? any thoughts??

Answer 1

Hi Etienne,

Could you provide the screenshot of your Office version like the picture below?

Moreover, could you test with a new file and provide the detailed steps about how you create the drop-down list?

Regards,

Zixuan

Answer 2

Hi Zixuan,

You are absolutely right, the permissions step works for standard cells, however it is not working for cells with drop downs.. or is there something I am missing?

Thanks for your help, hoping we can get a solution to this :)

Etienne

Answer 3

Hi Etienne,

According to the 7th~11th steps in the article I provided, you can set Permission. You can enter the password, then click Permissions to set Permission for the users in your domain. For example, you give user1 to edit cell $C$2 without enter the password, while other users have to enter the password if they want to edit $C$2.

Regards,

Zixuan

Answer 4

Hi Zixuan,

I will give that a go, ideally, I wanted it to be available to the individual without the need for a password... to work from their log in on the system.

Keep me updated if you have any other thoughts :)

Answer 5

Hi Etienne,

In your case, I would like to suggest you unlock ranges on a protected worksheet for users to edit. You can select the cell, click Review>Allow Edit Ranges>New, you can enter different passwords for every user (e.g. their username) or click Permissions to select the user in your domain. After that, you should protect the sheet. You can upload the file to cloud like SharePoint team site, the users will enter their password when they want to edit the cell. (Note: please choose Open in Excel, this function is not available in Excel Online.)

For the detailed steps, please refer to the Unlock ranges on a protected worksheet for users to edit part in the following article:

Lock or unlock specific areas of a protected worksheet 

Although it is a little complex that you need to create the range for each user, it can achieve your goal.  You may also monitor this thread to see if other community members have more easy solution.

Regards,

Zixuan