lock row

Hi all, I am looking for a VBA code which can lock the rows from column K to P based on any input of the same row's column J. I would want the row to lock once any info is written in the column J. Do not want it to be specific to a text. Currently I have: Private Sub Worksheet_Change(ByVal...

I've searched this topic and all I can find is how to freeze panes which I already have in use but I need a solution if one is out there to selecting a specific row to stop scrolling at the top of the sheet right under my top 7 frozen rows. I have rows 1-7 frozen at the top of the sheet and...

Hello guys, So I have an Excel file containing two sheets: - `Teams` (which contains details of teams and time schedule of their matches) - `Results` (contains calculation and number of matches and results, etc). What`Results`does is that each game that has launched status on `Teams` it...

Hello Forum, I've searched quite a bit on this topic but haven't found anything helpful to my needs so far. I'll organize this thread in headers to help you find things more easily. What I Want to Do is This: Once data is entered in both K and L columns, I want to lock the row which the data...

I am working on a spreadsheet that users fill in every hour. I have formulas for putting time stamps in column "B" when they add their initials to to column "A". They need to fill in other information in the row before they add their initials. Once they put their initials in then the entire...

I have a data table of students grades. In Row 1 I have the headers, in Row 2 I want "Points Possible" with corresponding numbers in each column. I want to be able to sort the grades without having the Points Possible row move when I sort it. I've tried Freeze Pane but it still moves when I...