lock

I have a listbox with code that runs after user makes a selection (clicks item). It's a Form Control (vs. ActiveX type). Right now, while the code runs (takes about 5 seconds to complete), user can immediately click another item on list and listbox selection changes (though click event doesn't...

I need a little guidance. I do not want to use Data Validation to restrict data entry in the cells as the warnings for accidentally typing will decrease productivity. I want the user to be able to select from the list in the Table column C and it lock the unnecessary cells so they can quickly...

Hi, I have a excel sheet that is used to calculate staff hours and the sheet is protected with a password to stop people changing it. It has checkboxes and fields which add up/minus etc depending on what is chosen, something that has taken awhile to produce and something I am proud of. I've got...

Does anyone know if there is code to lock the ribbon so that none of the tabs can be selected? Or even hidden and locked?

Hi, I have a spreadsheet with some formulas in to represent a receipt. I want to be able to lock the cells with formulas. I think this is easy enough. My trouble is I want to lock some cells to accounting GBP currency. basically so a figure can be entered but so that somebody cannot delete...

I have 3 cells that have a macro to change values via a command button and ctrl + R and ctrl + D. Those values change color as well with conditional formatting so you can see the change. How do I lock those cells with out getting a Vb error "1004". At which time I need to reboot pc. Basically I...

Morning from everybody! I have an electronic requisition DB that the production department uses to enter the parts needed on the shop floor. Warehouse people then print the req and take the parts down. This DB is open 24/7/365 I need to limit the time that production folks can issue new reqs to...

Hi I am trying to lock a cell (A1) based on the value of another cell (A2) (ie if the other cell's value is above 0) to prevent users from entering data in that cell in A1 if A2>0 How do I do this ? Thanks for the help

Hi, I am using excel for a survey which I will send out via email to respondents and want to - Prevent them from adding rows and or columns - Only be able to enter data in selected cells - Also write some rules/conditions that will appear with a prompt (i.e I ask respondents how they split...

Essentially have a VBA workbook where it allow the user I am giving it to to enter simple parameters like enter something in cell A1 and A2, press Enter and it will run my script and performance a task. But they are not able to go into the VBA editor or see my VBA code. Is this possible? Any...

Good day all! I have trouble protecting my sheet's data. I would like to lock my sheet but keep the label alterable/unlock. I know how to do it for cells, but for the labels I can not do it.:mad: While clicking on the protect sheet, there is no case for the labels to tick. Thank you in...

How to lock cells in excel

Hi all, I found some example but they are not exactly what i want. I enter data in A2, B2, C2, D2. When i enter data in E2 i would like that A2, B2, C2 and D2 will be locked. When i remove the data from E2 the cells will unlock again. And this for every row. So also for A3, B3, C3 and D3 and...

IDK what you call them but I use the $ sign in formulas all the time to lock the value of cell called out in a formula so that it does not change when I copy and past to a new location, so if you have an entire column or row of values that you want to change the $ signs in all at the same time...

I've seen just about every form of this except the one I need for my sheet specifically. In Row H starting at H5 I have a drop down menu with a Y/N option and it goes all the way down to around H950. I want to lock the remaining cells in each row seperately if N is selected. In my case if I...

Hi there! I am new to this site and pretty much anything macro related. I have a spreadsheet that I am trying to add a button and want it to have a macro on it that can lock/unlock the sheet or certain cells. I know that you can go to the "Review" tab and then protect the sheet or workbook...

Hi, in the formula below when I insert a row the reference F6 changes to row 7. I would like to lock row 6 but have F change to G,H, etc. I see online a few ways to do it with indirect or maybe row function but I can't get it right. Any help would be appreciated. Thanks...

I have a textbox on a worksheet that I want to autosize, but ONLY vertically. I see in its properties the option for AutoSize, but this will adjust the box both horizontally and vertically. How can I lock its width?

I want to lock cells H9 - H49 if H8 has an x in it. I know I can use Conditional Formatting for font styles, cell color, etc., but I don't see a way to use it to lock cells, Is this possible and if so, how? Thanks in advance

Hello all, I have a spreadsheet that has a cell that when one answers a series of questions a value appears in that cell. I would like to lock all of the questions after the answer appears. Any suggestions? Thanks.