I have a spreadsheet consisting of 6 'slots' and 7 fields within them. I have a field with a drop down menu in it. When the user selects 'Used Valet & Buff' in cell C5 I need from C9 to C22 to be locked out to allocate time for that specific job and not allow anyone else using this shared spreadsheet to allocate a job within those cells.
How would I go about doing this as I am new to excel macros and VBA?
Thanks in advance.