Folks, i have a management report supported by ten or so individual kpi reports. the kpi reports are all exactly the same as each other except each relates to a different site. all the tab names are the same and all the tabs contain the same structure. each KPI workbook is handled by another person. I have been asked to lock down the KPI reports so that only specific cells can be written to. this is, as you will all know, to stop the user changing anything they are not supposed to. I have gone through the first workbook and locked all the cells that need locking. I am ready to do the sheet level protection now and then on to the next one. its just so tedious. does anyone know how to copy the locked cell format from each tab within this "source" file to each of the other tabs respectively within the other workbooks