Witryna26 mar 2016 · Replied on March 26, 2016. Report abuse. Hi, Assuming that drop down menu list is in Sheet1, in cell A1. Since you are interesting, only for cells a2-a9 (lock … WitrynaThis Excel video tutorial demonstrates how you can easily lock or unlock cells of a particular colour or format. For example, you have may have created a fo...
how i can lock some cells automatically after specified date in excel
Witryna11 lip 2024 · I want to lock/unlock a particular cell, based on a value entered/updated in another cell. For eg. If I update string "NO" in cell A2, then the cell B2 should be … Witryna23 lis 2024 · Nov 24 2024 11:06 PM. @ajl_ahmed. How to lock or unlock cells based on values in another cell in Excel? In some cases, you may need to lock or unlock cells … cannot access class sun.security.util
Lock cells to protect them - Microsoft Support
Witryna26 mar 2014 · 1. Select all cells by clicking with the primary mouse button on the cell in the upper left that is the intersection between header letters and the row numbers. 2. … Witryna15 lip 2015 · Here I attach the related file. The goal is to protect column H6:H25 if the value is "Completed". In the process, if user select "Completed" value there will be … Witryna20 lis 2024 · Lock or unlock cells based on values in another cell with VBA code. The following VBA code can help you lock or unlock cells based on value in another cell … cannot access console root account is locked