Excel Tips: Lock an Excel Cell after Updating the data

[@indianmonster1445]

GooooD & Usefull......Tricks...........

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@omkarkelshikar7484]

Great sir nice video your video is very nice and very helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gajanandhumal8883]

Thanks bro..very informative and in simple language.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@marvelautomations4731]

It's help full us a.lot. thanks brother

[@PKAnExcelExpert]

Thanks for your valuable feedback. Please share it with your friends and colleagues

[@carolalao4703]

Thank you for sharing this video tips happy viewing learning

[@jeremierealon7607]

wow very clear for me,thanks man🤗🤗

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@MohAboAbdo]

Thank you so much Sir.

[@PKAnExcelExpert]

Most welcome

[@rickkeev4919]

Very Well explained!! Great Job!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@toufiqqureshisap]

Bhai Sab you made my.. Thank you so much .. I was struggling for this.🫡

[@PKAnExcelExpert]

Most welcome 😊

[@prashantparmar5014]

Your program is very nice. Can u explain with VBA code ?

[@niemalsmeister]

Thank you very much!

[@PKAnExcelExpert]

Most welcome

[@mikeseal3053]

Thanks a lot

[@PKAnExcelExpert]

Most welcome🙏

[@shimulrahman4769]

Great video!!!!!!!! How to switch pages on multi page user form with a search box? Please give me some solution.

[@PKAnExcelExpert]

Thanks for your valuable feedback. I will definitely try to make such video very soon.

[@denisfmbae]

Awesome, and how can one go about it in Google sheets.

[@tushargohad4545]

Excellent info. But if I want to lock particular cell i.e. particular rows/column A17: H22 then kindly share method for locking particular cell.

[@PKAnExcelExpert]

Will upload soon

[@birdview2010]

Thank You!

[@PKAnExcelExpert]

Thanks for watching

[@gangadharbhardwaj]

very nice

[@PKAnExcelExpert]

Thanks

[@aliawan1977]

Great work

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@vishudevkate1225]

If we protect sheet and update few cells multiple times?

[@bestscenes1469]

Great work Sir. I have a question which I believe you can help me solve. When i use this VBA with excel table it locks the table so when I add more data in the table it doesn't auto expand. Is there any way out .

[@nickson.wafula]

Great. How can I do the same on Google sheets

[@nobinjacob]

Does Tab key work on this excel when protected?

[@খামখেয়ালী-জ৯র]

How can we apply same think to lock the same in Google Sheet? Please make a video on this topic..waiting for video..

[@tushargohad4545]

One more query is that cell contains date which is passed or in future & user should not able to edit the particular rows as entered date is passed. If I entered only today's date, then that particular row shall be enable & editing is possible that particular row. Please guide.

[@sadhanap412]

sir. i want to lock some range for other users to do entry once i put data as it is shared file for multiusrrs how. it is possible

[@PKAnExcelExpert]

Great suggestion! I will try to create a video on this topic.

[@sdrakib8153]

Is it possible for specific Row or Coloum??

[@sdrakib8153]

If is it possible..please please give me these format..thanks in advanced bro❤️

[@madhavjha3891]

Thanks for Information Here while entering password it does not appear in " ****** " format. Please explain what addon will make it to appear in star format. Thanks Regards madhav

[@AliMohamed-jg6bv]

Thank you for your kind sharing. But I got problem on this method. Once you click on a cell within the range it will be locked even if you didn’t write anything. I need a code says: only activate cell lock when there’s entry otherwise keep it unlocked. Is that possible? Hope I make myself clear 😅.

[@brittanymaes9737]

Anyone know how to do this in Sharepoint's Scripts? I need this for a shared file

[@sulthansvm6834]

Hi without sql ho will get external data from the 🔗 link in application kindly provided this emergency basic skills

[@commonmanchennai]

Is it possible to do without VBA ?

[@usman5402]

Sir i have a request, plz make a tutorial about break even point with chart. And also describe assumptions how to calculate? Plzzz sir.

[@SujathaS-sx3kg]

Sir while using randbetween formula and if i press enter the values are changing how can i fix it.

[@Pardeepkumar-yt1sd]

Great

[@PKAnExcelExpert]

Thanks

[@AbdulMohamed-of9cf]

Since it uses VBA, it's not working in web version. Any method that I can use for a web version?

[@PiyushKumar-sx5kh]

मुझे एक्सेल मै पावर क्विरी का जो डाटा मै इंपोर्ट करता हूं उस प्रोटेक्ट करना है बता सकते हो कैसे होगा सर कॉपी भी नहीं होए

[@aliawan1977]

Can you make complete software for school in Excel.

[@PKAnExcelExpert]

I am working on a School Management Software. It will be completed soon.

[@aliawan1977]

Thanks

[@arqaankhan6673]

Where should I add the range here (i want only 2 columns to be locked after entering any data)

[@PKAnExcelExpert]

You can use Target.Column condition to put the restriction of cell lock.

[@Draken1070]

Hello, Thanks but what if I want to clear the table and start from scratch. It will always ask me to unprotect for every cell how can I avoid this?

[@karandrg7271]

सर नमस्कार मेरे फर्म मे 500 से जादा कस्टमर है और मै उन सबको excel मे अटोमेटिक invoice से sales कर्तेही जिस पार्टीको sales करु उसी पार्टीको हि mail जाय क्या ये सम्भब है सर कृपया कर्के रिप्लाई दिजिएगा

[@juliantrujillo-trujillo19]

Me quedó clarísimo su comentario jejej

[@ernestobanuelos7621]

I need to do this but After they hit Save button.

[@Sachin-j9e]

working this is ok but after close the excel and reopen and start in new cell and it does not work anymore

[@dmuralidhar4680]

Sir vdo very useful can u teach in hindi. Thank u sir