Need macro which locks cells (C57:C61) based on data validation selection (C1)

[mopetten]

Greetings,

This is my first post. Happy to be here.

The data validation selection for which I need the cells to lock are: "Pre-Hire Re-Hire C to I Conversion" AND "Pre-Hire - C to I Conversion".

In addition, if a notification could also pop-up which reads "No Referrals for C to I conversions."

Please let me know if I need to provide you any further detail.

Best,
mopetten

[tlafferty]

Welcome to the forum! Do you want the cells to lock instantly once the selction is made, or do you want the user to make the selction, then click a button to apply the change? It would also be helpful if you'd consider posting a sample workbook.

[mopetten]

Hi Tlafferty,

Thanks for replying. I'd like to to be instant once the selection is made.

mopetten

[tlafferty]

On your keyboard, press Alt + F11 to open the code window.
Double click ThisWorkbook, and paste in this code:

Please Login or Register  to view this content.

Note that you need to name your data validation drop down HireType for this code to work.