How to lock cells after entry is made in Excel.
Cells cannot be changed after the value is entered. The entire sheet is entered except for selected cells and the user is only allowed to enter the value once.
Allow me teach you the skills in Excel that you need for business
Let me teach you the VBA that I have learn in my five years of consulting
Become an Affiliate and earn 25% on Course Sales
Code
Private Sub Worksheet_Change(ByVal Target As Range)
ActiveSheet.Unprotect Password:=”test”
Target.Locked = True
ActiveSheet.Protect Password:=”test”
End Sub
For more help visit my website or email me at easyexcelanswers@gmail.com.
Contact me regarding customizing this template for your needs.
Excel one-on-one on-line training available. Email me to arrange.
I am able to provide online help on your computer at a reasonable rate.
Check out my next one-hour Excel Webinar
I use a Blue condensor Microphone to record my videos, here is the link
Check out Crowdcast for creating your webinars
If you need to buy Office 2019 follow
I use Tube Buddy to help promote my videos
Check them out
Follow me on Facebook
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I’ve used or have experience with.
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
Thank you so much for watching my video, let me know if this is working for you in the comments
how can I lock the cell after a specific time in real time in google sheet?
Thank you so much! This is exactly what I need!
Wow! Ma'm. This Amazing thank you so much. Never thought this was possible.
Hi there,
It worked for me yesterday and when I opened it up today, I keep getting a ‘50290’ error
Can you please help
amazing tutorial!!!
Not helpful at all; even you delete the data still the cell remain locked forever.
Is there a way to do this in google sheets?
Wow, thats so awesome mam 😀 yes i just subscribed.
can anyone help me, after i uploaded the excel online, it does not work anymore
thank for your help 🙂 godblessyou
Hi, loved your video, has helped with some problems i was having previously. Just wondering, im having another problem, are you able to unlock a specific cell only after an entry has been made in another specific cell, ie, unlock B1 after an entry has been made in A1? I appreciate it if you can help. Thanks in advance.
Thank you mam
Very helpful & easily understandable
it work like a charm, very good thanks. but I have a question. what about if I need to permanent unlock some of the cells not all of them but just a couple?
Hello there, very simple and easy to follow video. Thank-you very much. What I'm looking for is a way to lock various cells after another cell is updated. So based on your example it would lock cell A2 and B2 after I place an 'X' on C2, for example. I have a button to do a "submit" like function, but I want to prevent cells A2:C2 to be edited. A lot of other videos are explaining the same concept you were showing. Any help is much appreciated.
Amazing.Thank you.
The macro code did not work. Please check.
Perfect
Hi..
Is there any method to do same thing in Google Sheets?
Hi Barb! Is there a way to replicate this with a data validation list? Automatic protection once an option is chosen from a list.
Thanks!
Wow its very simple and straight forward. Many thanks
I've watched a dozen videos but yours gave me the direct, easy, understandable, and working solution! THANK YOU!!!
Hi Ms. Henderson is there a program which blocks the whole colon if there is a value in one of the cells of that colon.
hi, it not works with me ! i'm using office2010, it highliting the code ActiveSheet.Unprotect Password:="test" by yello. thank you for replying.
I’m trying to do a self schedule for our staff and need some help. Let’s say I 10 staff total, I need only 6 per shift, and would employees to be able to schedule on a first come first serve basis, but I don’t want them to be able to change others schedule can you help me I’m not sure how make it so that once a day is full you can schedule yourself for that day as well pleeease help!
Please teach me power pivot tables
Thank you
Hi Good morning madam
thank you
i think we can unlock the cell with psu. isn't it so??
Many many thank you mam.
Hello barb 🙂
I think that you are expert in vba. Would you please give us a training in excel vba. it would be very fun.