lock cells

Mock spreadsheet as per below. 1. I have a power query which has over 500 lines. (Column A - C) I have set conditional formatting to highlight specific cells containing the word "CANCELLED". The user of this report will need to scroll through 500 lines to identify any "cancelled" transactions...

Hi Everyone, In my VBA code, I am looking to form a loop which can check the variables in Column A and for couple of variables in Column A unlock cell/cells from column D and For rest of the variables lock cell/cells from Column D & M. Currently I have with error: Private Sub...

Hi everyone! I've hit a bit of a brick wall with my knowledge and could do with a hand. I've got a simple sheet, I need cells A2 - D2 filling in, then once there is content in that range, lock that range AND unlock the row below (A3 - D3). So far, I've managed to get it to lock the entire sheet...

Hi, Is there a way to lock a cell after data entry, with specific named users having access to write in any empty cell, but not able to overwrite data that has already been entered? I'll explain in more detail below.. I found a method of locking a cell with a password after data entry (i.e. if...

Hi, How do I prevent relative cell referencing with this formula? Dim LastRow As Long LastRow = Worksheets("data").Cells(Rows.Count, "I").End(xlUp).Row Range(Range("N2"), Range("N2").End(xlDown)).formula = _ "=SUMIFS(data!J2:J" &...

Hi there, I'm not sure why this code isn't working. Can someone tell me if I'm missing a trick please? Private Sub Worksheet_Change(ByVal Target As Range) If Range("A17") = "TRUE" Then Range("F17:K17").Locked = False ElseIf Range("A17") = "FALSE" Then...

Hi, First let me thank you for taking the time to read this thread. I am very new in excel, I have 3 cells (A1, A2, A3) and I would like to know if it is possible to lock one out of the three when two have data. for example; If I have A1="any number" and A3="any number" I want A2 to be...

Good morning, The spreadsheet I am working on needs the community's assistance. The goal would be to Lock 3 cells in the same row IF any alpha-numeric character is input in another cell. For example, if the user marks cell B12 - then lock cells C12, D12 and E12; if the user marks cell C12...

I am new to visual basic and need some help with some coding. I have a excel template that has an plan end date and actual end date (2 separate columns) if my actual end date is greater then my plan end date, I need a message box to explain they need to write a comment. If there is no comment...

HI! I've tried reading through different threads and sites trying to find something code that will work for me but I don't know enough (or anything) about VBA to modify them to work for what I need so I'm hoping someone can help me out. I have a spreadsheet set up for work that will be...

Hello, I am trying to create an excel file that will be shared with another user. I need the user to select certain responses on one of three sheets in the same workbook. I have 3 tabs named "Full View" "Customer View" and "Product View" all showing the same information but in different...

Good afternoon all, I have working on different ways to lock cells without protecting the worksheet. I have found the following code to perform someway to what I am looking for: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column = 6 Then If Target.Row...

Hi all, I'm trying to lock down table edits but need to allow sorting AND executable hyperlinks.. Please help, can't find a solution that works for both. 'Allow Users to Edit Ranges' + all cells locked -> allows sorting but can't click the cells with hyperlinks 'Allow Users to Edit Ranges' +...

I have already asked a similar question but I am still not getting the results I had hope for. My goal is to have for instance an entire worksheet that is locked so that other users cannot change anything. However, there will be an exception of cells like C6, C12, C18, etc.. In these particular...

I am creating a program within Excel where the workbook will be used by multiple players. Each player will be on their own sheet within the Workbook itself. Each sheet references answers selected in others sheets. Part of the program prompts users to select an answer from a drop down menu, so...

I would like to be able to check (without use of Exception Handling) to see if a single cell's Value/Value2 Property can be changed or not. For example I will not be able to change a cell's value if the cell is Locked and its parent worksheet is Protected. I also won't be able to change a...

Hi, I have a Yes / No data validation list in column A. When Yes is selected I want rows B - T to be locked and want it unlocked when it is empty / no is selected. The below code works brilliant but only when one cell is inputted with Yes. When multiple cells in column A are inserted with Yes...

Hello... I have a CountA formula, see below... =COUNTA('0 Data Summary'!B10:B108) I have a macro that creates a new client data row in row 10, and all other client data shifts down by 1. It works fine. Now, I have some formulas on Report tab that pulls this data using similar formulas like...

Hi all, I have a sales pricing model and i need to lock access to a cell if another cell contains certain text. For example: If C7 = "Existing Client" then F14 is editable If C7 = "Prospective Client" then F14 is not-editable At present, the spreadsheet is not protected, but once i get this...

Hello, Any ideas as to why this will not run. I've been playing with it all day and can't figure out why it stops after the If statement is evaluated. I'd bet money it's something minute I'm overlooking but I can't find it. I have changed everything I can think of in the two statements...