Auto Lock Cells After Enter the Data (Advance Excel Tricks)
23.7 هزار بار بازدید -
6 سال پیش
-
Private Sub Worksheet_Change(ByVal Target As
Private Sub Worksheet_Change(ByVal Target As Range)
Dim xRg As Range
On Error Resume Next
Set xRg = Intersect(Range("A1:E15"), Target)
If xRg Is Nothing Then Exit Sub
Target.Worksheet.Unprotect Password:="1234"
xRg.Locked = True
Target.Worksheet.Protect Password:="1234"
End Sub
Learn How to use "Auto Lock Cells After Enter the Data" in hindi, How to work with this function it can help you greatly in your calculations.
join us on:- https://www.facebook.com/learnexcelinhindi
Subscribe us :- https://www.seevid.ir/fa/result?ytch=UCvXiBsoS0BVu_KWFioKZktQ
MY BLOG SITE :- https://learnexceltallysap.blogspot.in/
About the channel
Learn Excel in hindi is a education channel, here you can learn basic to Advance excel in hindi & easy Way.
-~-~~-~~~-~~-~-
Please watch: "How to Export and Import Data in Tally"
https://www.seevid.ir/fa/w/lnUR2mk2RDo
-~-~~-~~~-~~-~-
6 سال پیش
در تاریخ 1397/12/14 منتشر شده
است.
23,751
بـار بازدید شده