Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Allow Only Certain People to Edit Specific Cells in Excel

0

I was watching the

https://www.teachexcel.com/excel-tutorial/allow-only-certain-people-to-edit-specific-cells-in-excel_1463.html?nav=sim_bttm_pg

tutorial. however I can't find the allow user edits thing in my version. I'm sure it's there somewhere. even when I searched Excel help it showed a different version to mine

Any thoughts?

Answer
Discuss

Discussion

Albert. Next time, try to use the LINK button and add the title and URL (I think the Forum's Rules ask you to do that, in case the link is moved there's still a subject/search term)
John_Ru (rep: 6092) Sep 29, '21 at 4:00 am
Add to Discussion

Answers

0
Selected Answer

Albert

I think Excel 2019 is the same as my 356... In an unprotected sheet, go to Review on the ribbon and look in the Protect subsection- there should be a button "Allow Edit Ranges" (to the right of "Protect Workbook"). Click that and you'll see a requestor "Allow Users to edit Ranges".

If you don't see that button, right click the ribbon and choose "Customize the Ribbon..." and see if "Allow Edit Ranges" is unchecked.

From your file (now in the question), I see you've accessed that button and have a requestor showing no users with permissions for the range Store1. If you want to make the sheet protected by a password for all users, follow the other steps in the tutorial.

If you want to allow some users to access without (or with) a password, follow the screenshots in the attached file where I've searched locally for a (known) user called "john" (me!). Start of arrows indicate the buttons to click or tect inoput/output. In a corporate setting, you could have lots of netwrok users but I'm not working anymore so can't illustrate that.

Hope this covers what you were trying to do.  

Discuss

Discussion

I use Excel 2007 and it is at the right side of the review tab of the ribbon.
WillieD24 (rep: 537) Sep 29, '21 at 8:54 am


this is what I have
wildecoyote1966 (rep: 28) Sep 29, '21 at 8:26 pm
Hi John
I can't put a link as my points are to low.

Putting clickable links in questions/answers/discussions. (15 reputation points)

soon hopefully
wildecoyote1966 (rep: 28) Sep 29, '21 at 8:32 pm
Okay Albert, I'd forgotten that links required reputation points..

When you said "this is what I have", I assume you mean you don't have Excel 2007 (since your profile says 2019) but attempted to post a screenshot- that doesn't work on the Forum (but you could paste one into an Excel file).. 

Or did you find the button?
John_Ru (rep: 6092) Sep 29, '21 at 11:42 pm
Albert. Did you find (or add) the button eventually?
John_Ru (rep: 6092) Oct 4, '21 at 10:13 am
Hii John
Sorry been a busy with RLS
no I haven't sorted it. I only have Excel2019. it's not urgent just an idea I was having.
And yes I did try post a screenshot
wildecoyote1966 (rep: 28) Oct 5, '21 at 3:06 am
Albert. Please see revised answer/ embedded screenshots.

Not sure what RLS is but hoping it's not the medical (Restless Legs Syndrome).
John_Ru (rep: 6092) Oct 5, '21 at 4:45 am
Thanks John

Oh RSL = real life stuff
not medical for now. we just purchased our house then solar panels etc. organising a new fence. the list go on lol
wildecoyote1966 (rep: 28) Oct 6, '21 at 2:32 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login