lock cell

  1. H

    How to lock a cell under if 1 condition is TRUE

    I want to ‘lock’ cell D2 IF H3=1 How to accomplish this? Thanks in advance.
  2. S

    How to reference locked cell in VBA?

    I want to be able to double click a cell and then insert a row under the clicked cell that copies the formula from the above locked cells. When the sheet is unprotected, the code works fine. But when I try and the sheet is protected I get the error below. Is there a work around?
  3. S

    Excel VBA to lock cell from being edited

    I have a cell in Sheet1 (code name) that I would lock from being edited followed by the use of being prompted to enter a password. Here are the details: Sheet1 cell C2 locked from being edited, then enter password to inhibit users from just manually unlocking the cell. Thank you!
  4. L

    lock/unlock cell based on value in other cell

    Hi Guys, I want to lock fields when a specific cell is empty and unlock it when that specific cell contains a value. Example: <colgroup><col><col span="5"></colgroup><tbody> A B C D E 1 Fruit Banana Pear Orange Apple 2 Apple locked locked locked unlocked 3 Banana unlocked locked...
  5. T

    ActiveX Text Box with scrollbar

    I have an ActiveX textbox with a vertical scrollbar. In an attempt to prevent editing, I did two things: the locked property is set to true, and the data is linked to a locked cell. The issue that I have run into is that (while the sheet is locked) I can edit one character at a time. Every time...
  6. J

    Adding new cells to sheet protection

    Good Afternoon, BLUF: Is it possible to add new cells to a sheets' "protection/lock" without supplying the original password?... I was tasked with making a "logbook" document that would act much like pen and paper. I've gotten a macro to add a new line to the top of the worksheet (keeping the...
  7. P

    VB - Protect Cells if Date in column A is less than this month

    Hi all. long time reader, first time poster. I am looking for help on this one. I have an excel sheet where data is entered on a monthly basis. I want the rows to be locked if the date entered in column A for each row is older than the current month. Therefore users will be able to enter...
  8. T

    Cell stays the same if condition is true, regardless of factor changes

    So I have a page designed to help me pay large sums of money back to someone by giving them a percentage of what I earn each week. The parts I am concerned with look roughly like this: Self Input Title Formula <tbody> % to pay each week: 10% Week Total Amount to pay Paid? $100 $10...
  9. T

    Sorting a table in a protected sheet when some cells are locked

    I have a form which people will use to enter data in a standardized way. The table has columns A:C as formulae and columns D:G as empty cells ready for people to add the necessary data using a mix of Data Validated pick lists or free-form text. I've locked columns A:C to prevent people...
  10. S

    To lock and unlock cells based on input

    I am working in excel 2003. I have a drop down box in a cell which has two options say A and B. I want certain cells to lock themselves based on input from the user, means if user selects A cells from A5 to A15 should get locked. Similarly B5 to B15 should get locked if user selects B. So I was...
  11. G

    Turn on cell lock if conditional format rule is true

    Dear All, I am trying to create a macro that will set the Lock check box to True for a cell if Conditional Formatting rule #1 for that cell is True. I borrowed some code and ended up with the following that does not work correctly. This code never results in a True. I don't understand...
  12. S

    Allow entry only once

    Hello all, I have requirement wherein each cell should be allowed to edit only once. This has to be done for a range of cells. For eg. A1:A10, C1:C10. I have found the below code but it is not working as desired. The second time when you enter in the same column (any other cell) it doesnt...
  13. A

    How to lock cell

    Dear Sir, I'm using excel for a while, now I would like to seek your help I create excel sheet for my colleague to input data (only one cell) , what I want to do is how to lock cell immediately after they hit enter and cannot do anything just save only (not save as). Thank you very much for...
  14. B

    Lock entire row based on cell value which updates by a formula, not entry

    I have seen many posts for locking a row based on the value in column A, for example. This works if I manually change the value in column A. However, I am trying to determine the coding so that if I have an If statement in column A, returning the values "x" or "", for true or false...
  15. B

    Unprotecting a Range

    Hello all, So I have a Userform, which contains a button then when clicked, directs the user to a worksheet where they have to enter information into certain cells. I am trying to protect this worksheet, except for this specific range of cells, which I would like to leave unprotected. I...
  16. L

    Conditional Locked Cells

    <TABLE cellSpacing=0 cellPadding=2 width="100%" border=0><TBODY><TR><TD align=left> I would like to lock a cell if a specific word is entered into another cell and unlock it when any other words are entered.For example I have a dropdown list in K2 that has either "Agree" or "Disagree". If one...
  17. F

    Lock individual columns -not entire tab- in 07

    How does one lock certain columns in a spreadsheet without locking the entire tab? I've gone through countless attempts and each result in the entire sheet being locked. I'm using '07. I've tried it both with and without checking the "Lock Cell" under the Cells>Format on the ribbon. Also, does...
  18. D

    Navigating with protected worksheet.

    OK, so this is really puzzling me. I have only cells K1:AF1 locked and my worksheet protected. As expected, I cannot select these cells but I can select all the other cells. The problem occurs with navigating the worksheet, anytime I hit the enter key, the up key, or the down key; I end up in...
  19. A

    Conditional locking/deleting?

    Hi, My question is: I'd like to lock and delete the contents of several cells depending on the content of a different cell. More specifically, If F4 has any value at all (the options are "Individual", "Individual + Spouse", "Individual + Child" and "Family" -- my spreadsheet is about health...
  20. K

    Lock cell if based on value of corresponding cell

    Hi, I was tring to lock cell if value of corresponding cell is error If value B3:B20 is error lock corresponding cells in ColumnE, F & H OR unlock cell if value of corresponding cell is >0 If value B3:B20 is >0 unlock corresponding cells in ColumnE, F & H

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back