My code will check if specific cells are changed. With the information you provided that's all I can do. The selcet case needs extending to cover your other cells.
If the sheet is protected then you need to unprotect it within the code, then protect it. Otherwise, you can protect withuserinterface only.
Does it work on AB19?
Hello again,
I removed the Case 20 part but the code wasn't making any changes based on AB19, I don't know why.
Actually I changed the approach and made 10 drop down combo boxes and linked the references cell with a macro. Seems to work and I think less trouble than having a macro run in the background everytime someone makes any change.
Thanks for your help Roy