lock cell

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

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?

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!

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

<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...

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...

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...

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...

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