I need vba code in the sheet.if a cell contains value "Abid" then the whole row will be locked and become non editable till we change the cell value.
Thanks for urgent reply
I need vba code in the sheet.if a cell contains value "Abid" then the whole row will be locked and become non editable till we change the cell value.
Thanks for urgent reply
Hello mubashar,
If the whole row is locked and non editable, how do you plan to change the Cell value?...and become non editable till we change the cell value.
Regards.
Last edited by Winon; 06-29-2016 at 04:42 AM. Reason: text
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Maybe try Data Validation?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
@FDibbins,
Exactly what I thought as well, but since the OP wanted VBA, I could not resist posing my question.
Groete my vriend!
Hey boetman, will be in your neck of the woods again soon - visiting son in CT and sis in Durbs
Hey old man, any chance with a stop-over in Jhb? If not, I don't think I will ever use your travel agent. LOL![]()
Not sure what the travel plans are but I think we stop in JHB, will get you the details
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks