WebJul 26, 2016 · Re: Auto lock cells after data entered and SAVED. I really appreciate your response. I'm having a couple of issues that you may be able to clarify or correct: 1. I'm assuming that the passwords are the lab techs, Allie-Yolanda. If this is true, when I use any of the names, I get a message stating that the password is incorrect. 2. I'm wanting ... WebNov 21, 2003 · Private Sub Worksheet_SelectionChange (ByVal Target As Excel.Range) If Range ("a1").Value = "" Then Range ("b1:c1").Locked = False Else Range ("b1:c1").Locked = True End If End Sub This code needs to go into the CODE for the SHEET. Click to expand... Locking the cells won't do anything unless the sheet is protected. 0
locking cells after input, or showing if input has changed
WebMay 28, 2024 · Protecting cells in Excel but allow these to be modified by VBA script. I am using Excel where certain fields are allowed for user input and other cells are to be … WebTo lock all cells that contain formulas, first unlock all cells. Next, lock all formula cells. Finally, protect the sheet. 1. Select all cells. 2. Right click, and then click Format Cells (or press CTRL + 1). 3. On the Protection tab, uncheck the Locked check box and click OK. granite and tile outlet allen
How to Lock Cells in Microsoft Excel - How-To Geek
WebSelect the cells you want to lock. On the Home tab, in the Alignment group, click the small arrow to open the Format Cells popup window. On the Protection tab, select the Locked check box, and then click OK to close the popup. Note: If you try these steps on a workbook or worksheet you haven't protected, you'll see the cells are already locked. WebFollow these steps to lock cells in a worksheet: Select the cells you want to lock. On the Home tab, in the Alignment group, click the small arrow to open the Format Cells … chings bloomington il