Hi, am working with two workbooks possibly more if this works. I have one workbook with various cells linked to a sheet in workbook 2. Workbook 2 changes it values based on a a drop down list. So when the right dropdown list is selected and workbook 2 populated and if this corresponds with a certain cell in workbook 1(analyis) then that cells is filled. My problem comes when I now try to populate other cells and change the drop down list meaning the cells that were filled in workbook one will then lose their values. So now am looking for a VBA code that will lock each cell so that even when the linked values in the feeding workbook are changed the cell wont change.