lock row

  1. N

    VBA to lock rows based on any input of a specific column

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

    Stop Scrolling a select row

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

    How to make entire row connected together ?

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

    How to Lock Row or Range of Cells After Data Entry of Specific Range of Cells - Excel 2010

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

    Macro to Lock entire row after input

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

    Lock row within a data table?

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

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
Back
Top