Dear Expert,
In my worksheet i want lock those row which row column A cell contains data "George".
Like if row 2 column A cell contain data "George" then total row will lock & if multiple row column A contain same data "George" then all those row will also lock automatically if i want to lock and other row will unprotected.
Attached sample for your ref.
Please help me in this regard.
regards
wahid
This can’t be done without VBA - shall I move the thread for you?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Dear Ali,
Please proceed.
This thread is now in the VBA section.
To Sheet1 code module.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks