lock cells after editing

  1. O

    Lock single cells after data entry

    Hi, I've searched around and tried different scripts online but none worked in my case. I'm making a break list for the team at my new job. The purpose is for employees to double-click on 1 cell, have the current time input, go on break, come back, double-click on a 2nd cell, have the current...
  2. tlc53

    Lock edited cells with Macro Button

    Hi there, I have found instruction on how to lock cells immediately after data has been entered however, I'd like to lock the cells with a push of a button/macro. Is this possible? Data is currently entered in B12:K105. I would like it so when they hit the "Transfer Journal" button, any cells...
    • tlc53
    • Thread
    • cells data lock cells after editing macro button vba & excel 2010
    • Replies: 11
    • Forum: Excel Questions
  3. F

    VBA Lock Cell in row if yes in selected

    Hello, I have the following code to lock the entire row, if the cell selects Yes, but how can I just lock the row from column a to Cd if cell.value is yes. I also then want to say if cell.value="No" , unlock the row and if it's "" do nothing to the row. Private Sub...
    • FN1234
    • Thread
    • lock cells after editing lock cells based on range row selectionchange vba
    • Replies: 5
    • Forum: Excel Questions
  4. D

    Lock Cells After Editing

    I have a spreadsheet in which I'm gathering information from multiple people. I've LOCKED some cells that I don't want people to change and I've enabled the ability for MULTIPLE users to edit the sheet at the same time. Once a user inputs information I'd like to be able to LOCK the cell so...

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