• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Lock a cell containing data validation post selection of result

V

Vipullade

Member
I have a file which has data validation in a column, the values are from 1-5, post the user selecting any one number the cell should get locked, please assist with this.
 

Attachments

I need to use this sheet multiple times, which means I would have to unlock the cells every time It is to be given to the user
Am I correct on this
 
That would be a great help, I am myself learnihng VBA but still in a very nascent stage....Really appreciate yout help
 
Hey Narayan, need help in this, I modified the reset code to reset the cell values to "Please select", but due to this all the cells in the range are locked, i need them to be unlocked and lock only if the values are between 1-5 both inclusive..can you help please
 
Public Sub ResetLocks()
[dataentrycells].Locked = False
[dataentrycells].Value = "Please Select"
End Sub
Code for your reference
 
Sorry to be a bother but Now I need to link the locking code to a command button, can you help on this as i tried doing it but dont know what i am missing, I put an active x button and tried linking the locking code but it wont work.....Please help
 
The password is Big5@123, i have used the same code you provided narayan, in the command click sub but it is not working, i am mssing on something, but could not figure it out.. please help
 

Attachments

what I am looking for is now that the cells remain unlocked untill the submit button is selected, once the submit button is selected, all the cells in the range f8:f106 in the test sheet should be locked
 
You must log in or register to reply here.
Back
Top