Lock a Cell for Editing IMMEDIATELY After Changing it - Excel VBA Is Fun - Speedtip!

Apinan wanted to have the user edit a cell, and as soon as they exit the cell or hit enter, the cell would be locked and no longer editable. Here's the quick solution we found to help him. Try it out!

------------------------
------------------------

To download this FREE workbook(source code included): Click the link below.

------------------------
Playlists:
------------------------

Grab an Excel Nerd T-Shirt or Hoodie:

------------------------
Interact and Follow me on:

[kabelokelepile]

Perfect -I found this very vital to my work.

[Juchrisad]

Very straight forward and simple to follow - Thanks

[marksh]

i want code to don"t change one textbox onley can change any textbox except one in userform
thanks

[jaredmajors-manley]

I found this video extremely helpful. But I need to lock a range of cells only if the user changes a value and saves the workbook? Any ideas?

[yehoshuvaandco]

what about the dropdown menu, and changing the colors as per the options available in the drop down menu in the above protected vba mode.. Thank u

[jpacello]

Is it possible to only have certain cells auto lock and be unchangeable? I have only about 10 cells that I would like to lock after data is entered. All the other cells can be freely edited over and over. Is this possible?

[ripvista]

Is it possible to auto protect a cell range i.e (c4:c9) plus a separate cell i.e (j29) after data entry and have a message box display only for cells in range and J29 with a yes no response (vbYesNo) to verify data, where yes locks cell and no lets user re-enter data. Only these cells. The rest of the sheet has formulas and locked/unlocked cells

[CanadaSocial]

Thanks a lot for this. How can I get grouping to work on locked cells and protected worksheet? I want to share a sheet that is protected but allow the end user to use the grouping toggle to hide or unhide columns. Also can you advise me on how I can lock a group of cells in a column based on the value of a table header that has future or past

[emanalbar]

Thank you so much. I learned a lot from you.

[hassanzahid]

Hi Dan, Your video was very helpful in making me understand how to lock cells right after input. However would you be able to help if i want to lock the cells after the files have been saved. I have no indepth knowledge of excel please help.thanks

[christalrobison]

Very helpful, but I was wondering if it was still possible to get a copy of the Essential Excel VBA Snippets book you talked about in this video? There was no link to click on as described.

[harshsurana]

Hi,
Can you please help me achieve the same thing in Google Sheet ?
Thank You

[mykitchen]

Sir, may i know how to auto lock cell after enter data in google sheets ?

[johnmagombo]

Thanks a lot for this. This is helpful

[lycanthropyyyyyyyyyy]

How do you protect 3 different sheets(1wb) in different times

[laurendean]

is there a fast way to add this programming to the workbook or do you have to protect each worksheet

[pepejunction]

How can I founded in my Excel-2007 option is "Developer" under VBA Projected. Pls advise me.

[syedabbas]

i have an excel sheet for data center visitor log in which i want to run 2 codes in vb which enters date and time automatically in date and tiem column and then protect the column so that it cant be changed or edited after entering data in all the columns.

[JohnPauljackulinbaby]

hi
It is working nicely, thanks a lot

[rameshvazhipokkil]

what about merged cells? debuug error!!!