Excel 2013 - Lock Cells dependent on anothers contents

Hiya,

I am looking for a macros to lock a cells dependent on another's value

I have a spread sheet for quote numbers I don't want the employees to take a quote number (A) unless all cells have been completed in cells (C-K)

however there is another condition within this where if cell K says yes then lock Cells N O and P, however if it says No these cell must also be completed to take a quote number

I have also added a macro to force enable macro with a welcome page and a macro to log the user name date and time of entry, I don't want to loose this it seems each time I try a macro for the locking cells or data validation it disables these macros

Any ideas would be greatly appreciated

Thanks Suzanne

Hi Suzanne
It would help us if we could see a copy of your workbook (take out anything sensitive).
Thaks
Tony