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.
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!
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
Did you learn how to do it?
Great video, step by step simplified.. how do you unhide the VBA code that you just applied?
Is it possible to lets say only lock column B and let all the others be unlocked after data is entered?
Will this work if I gave the user three options and the user just have to choose one of the provided options?
It should.........pls. try and share.
@@ExcelDestination I did it... it worked!!! Thanks for your help😊
Congrats!
The video was helpful but I was wondering whether we can do a similar thing in google sheets?
there must be some way to do that........I am not sure.....
Where is the 'expand button on the left side' you refer to after entering the codes?
How to extend this for multiple sheets in the same worksheet?
Thanks
Thanks so much! this was very helpful.
big thumbs up on this video
Thanks!
Sir, what is the code for redo n undo in vba?
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.
Click the cell - click review - click unprotected sheet - type password - make desired change - hit enter
thanks for the video
Good Explanation
sir, topic is good but your video resolution not good so we can't see the codes please updated good video resolution
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!
can you type the code .and my next question is what is the vba confirm code after entry data
It's not work with formatted table. Plx help
It won't work with formatted table because formatted tables go by table's in built functionalities. We have different solutions for that.
@@ExcelDestination let ms know the solution plz.
sure! I will create tutorial for that soon!
Kanye wont play this on a steinway. 😅😅. They obviously are in control of all music.
hello
error '424'
please help
same problem here :(
Error 1004
without looking at code, can't say anything
@@ExcelDestination I solved, if you try to use the code on combined cells dont work