VBA to Lock cells After Data Entry - Excel VBA Example by Exceldestination

This tutorial explains about VBA Code to Lock Cell immediately after entering data to avoid and change in entered data.

[@shivakumar290]

Thanks for the video, I wanted to see how to unprotect the same excel to correct if somebody wrongly entered it and we can correct them

[@jonathankrimer]

Did you learn how to do it?

[@tool1gt]

Great video, step by step simplified.. how do you unhide the VBA code that you just applied?

[@GetFactual]

Is it possible to lets say only lock column B and let all the others be unlocked after data is entered?

[@marangelyhernandez994]

Will this work if I gave the user three options and the user just have to choose one of the provided options?

[@ExcelDestination]

It should.........pls. try and share.

[@marangelyhernandez994]

@@ExcelDestination I did it... it worked!!! Thanks for your help😊

[@ExcelDestination]

Congrats!

[@jamesobuobie2983]

Where is the 'expand button on the left side' you refer to after entering the codes?

[@jeremierealon7607]

big thumbs up on this video

[@ExcelDestination]

Thanks!

[@sasankasamarajeewa9263]

How to extend this for multiple sheets in the same worksheet? Thanks

[@archanaaa2514]

Sir, what is the code for redo n undo in vba?

[@ExcelDestination]

I don't think there is any vba code for undo. You can take backup of your data and work before running any macro or code. Normally in excel we have Cntrl + Z command for undo.

[@patrickcarney3110]

Click the cell - click review - click unprotected sheet - type password - make desired change - hit enter

[@nap163020]

Thanks so much! this was very helpful.

[@shalinigupta1419]

Good Explanation

[@bhaktijoshi9809]

The video was helpful but I was wondering whether we can do a similar thing in google sheets?

[@ExcelDestination]

there must be some way to do that........I am not sure.....

[@shalinigupta1419]

thanks for the video

[@jonathankrimer]

Kanye wont play this on a steinway. 😅😅. They obviously are in control of all music.

[@loveglory4802]

It's not work with formatted table. Plx help

[@ExcelDestination]

It won't work with formatted table because formatted tables go by table's in built functionalities. We have different solutions for that.

[@loveglory4802]

@@ExcelDestination let ms know the solution plz.

[@ExcelDestination]

sure! I will create tutorial for that soon!

[@pbtechpro]

sir, topic is good but your video resolution not good so we can't see the codes please updated good video resolution

[@ExcelDestination]

Thanks Prandeep for watching! I am not sure...but you can try to set the resolution to 480 by using setting sign in bottom. Also, next time...I will try better for you!

[@pbtechpro]

can you type the code .and my next question is what is the vba confirm code after entry data

[@trstfv]

hello error '424' please help

[@feupinho83]

same problem here :(

[@nicolasangel562]

Error 1004

[@ExcelDestination]

without looking at code, can't say anything

[@nicolasangel562]

@@ExcelDestination I solved, if you try to use the code on combined cells dont work