Home > How To > Allow Users To Edit Ranges Not Working

Allow Users To Edit Ranges Not Working


Excel Tutorials Project Tutorials Outlook Tutorials PowerPoint Tutorials Word Tutorials Access Tutorials Visio Tutorials Publisher Tutorials Windows 8 Tutorials home courses Microsoft Excel Training MS Project Training Microsoft Word Training Microsoft Through unlocked ranges, or something else? When I run it, I come up with an error and it gets stuck on the line If shSht.Name <> "Main Form" Then shSht.Visible = False Next shSht Was I supposed Finding the lines with the lowest value in their third column given grep results more hot questions question feed about us tour help blog chat data legal privacy policy work here

How to prove that authentication system works, and that the customer is using the wrong password? Personally I have never tried it. I wish I could jump right on it and give it a shot (but unfortunately I need to get to higher priority items). Join lists by observing x-value "president-elect" grammatically correct?

Excel Lock Cells From Editing

Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. Code: Dim shSht as Worksheet For each shSht in worksheets if shSht.Name <> "Main Form" then shSht.Visible = False Next shSht Select Case UName case JHubbert SHeets("Hubbert").Visible = True case JaneMayal In the Refers to cells box, type an equal sign (=), and then type the reference of the range that you want to unlock. Sign in Share More Report Need to report the video?

Subscribe to Blog via Email Enter your email address to subscribe to this blog and receive notifications of new posts by email. Instead of using permissions that require a domain, you can also specify a password for a range. My cat sat on my laptop, now the right side of my keyboard types the wrong characters Should I have doubts if the organizers of a workshop ask me to sign Unprotect Excel Sheet Without Password Please try the request again.

Encasing a star in a perfect insulator A stupid cipher? Protected the sheet, protected the workbook and only allowed users to select unlocked cells. Danny Rocks 358,096 views 7:33 Allow Users To Edit Ranges In #Excel - Duration: 3:37. https://support.office.com/en-us/article/Lock-or-unlock-specific-areas-of-a-protected-worksheet-75481b72-db8a-4267-8c43-042a5f2cd93a In the Title box, type the name for the range that you want to unlock.

Edit objects Doing the any of the following: Making changes to graphic objects including maps, embedded charts, shapes, text boxes, and controls that you did not unlock before you protected the How To Freeze Cells In Excel Sign in to add this to Watch Later Add to Loading playlists... share|improve this answer answered Aug 7 '14 at 13:18 doggyTourettes 10615 Your link is the same as the one I linked to myself. Then click OK to close Select Users or Groups dialog, and you can see the user name has been added into the Permissions for Range1 dialog, and you can define whether

How To Lock Cells In Excel To Prevent Editing

Making any changes, such as formatting, to an embedded chart.

Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jul 9th, 2013,10:48 AM #8 kmcantrell New Member Join Date Jun 2013 Posts 8 Re: Excel 2010 Allow Users Excel Lock Cells From Editing All rights reserved. How To Lock Cells In Excel 2010 Users can change the values in the changing cells, if the cells are not protected, and add new scenarios.

Sign in to report inappropriate content. Not the answer you're looking for? After you turn on protection in the worksheet, only the users you've designated are able to edit the cell range or ranges you've defined. Please try again later. How To Lock Cells In Excel 2013

Teenage daughter refusing to go to school Why do we holler *at* someone but talk *to* someone? I have allowed specific users the ability to edit specific ranges on their sheet. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Jul 8th, 2013,10:55 AM #6 kmcantrell New Member Join Date Jun 2013 Posts 8 Re: Excel 2010 Allow Users If you lock the entire worksheet with no custom set of cells, they are all locked regardless of the permissions you have set.

If prompted for a password, type the password that you specified. How To Lock Formulas In Excel Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc. If I double-click a cell - any cell, regardless of whether it's in the range or not - I get the customary Cell is Protected message.

Insert hyperlinks Inserting new hyperlinks, even in unlocked cells.

So now John opens this workbook, all he has to do is to either double click into his range or start typing into that range. In the past I have done this differently, see this thread Can you limit or control the AutoFilter? Sort Using any commands to sort data (Data tab, Sort & Filter group). How To Lock A Cell In Excel Formula Add comment Name (required) E-mail (required, but will not display) Notify me of follow-up comments Refresh SendCancel HomeDocumentsSupportPrivacy PolicyContact UsCopyright © 2009 - ExtendOffice.com | All Rights Reserved.Microsoft and the Office

By default, users are allowed to select locked cells. I will try it in a bit and see if I can get this to work. When you finish adding ranges to the Allow Users to Edit Ranges dialog box, you're ready to protect the worksheet. Register Help Forgotten Your Password?

In that case, you must remove protection by clicking the Unprotect Sheet command button on the Review tab before you retry Step 1. Delete rows Deleting rows.