I would appreciate some guidance on how to lock a specific range of cells in a row based on the selection from a drop down menu in a different cell. For example if "Group Meeting" is selected from the drop down menu in K26, then cells P26-S26 would be locked. But if "Individual Consultation" is selected only cells L26-O26 would be locked. Is there a simple way of operationalizing this without creating a program? Thank you!