This might be really simple for you guys, but i am having no luck on my own. I have a validation list set for column Q. In the list i have 7 possible options. What i want is a VBA Code so that when option 7 is selected (eg. "Received") the cell in column Q with the word "Received" will be locked.
Do you want all the cells containing "Received" in column Q to be locked or only the active cell where you select "Received"?
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Once "Received" is selected from the list the cell should lock so no further changes can be made.Originally Posted by Mumps1
Start by unlocking the cells in column Q that will contain drop down lists and then protect the worksheet. Next, copy and paste this macro into the worksheet code module. Do the following: right click the tab for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make a selection in column Q.
Please Login or Register to view this content.
Mumps1,
Thanks for your quick response. I have used the code but when i click on the list in column Q, its pops up window asking for the sheet password to unprotect. Can it work automatically locking the cell with out the pop up. Column Q id unlocked even though the sheet is password protected.
In this code, change "mypassword" (two occurrences) to the password you are using.Please Login or Register to view this content.
I replied earlier but seem it did not go. Where i am the internet quality is what it used to be when there was dial up. Anyway thanks for the support. One quick question again as your codes make me think of more scenarios. If i wanted to capture date when the word "shipped" is selected from the validation list in the cell next to the validation list and even when it change from “shipped” to “Received” the date will stay locked to when “shipped” was setected.
I think that it would be much easier to follow if I could see how your data is organized. Perhaps you could post a copy of your file. Include a detailed explanation of what you would like to do using a few examples and referring to specific cells.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks