ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   keeping cells locked and protected when copying and pasting (https://www.excelbanter.com/excel-discussion-misc-queries/94677-keeping-cells-locked-protected-when-copying-pasting.html)

Lynne......

keeping cells locked and protected when copying and pasting
 
Hi
So i have sheet 1 with some cells locked and protected (but open to copying)
as a template and sheet two will be where people paste one or more of the
template formula on an ongoing basis. How do i mantain the locked and
protected cells after they have been pasted?
I have unlocked sheet two pasted the first template and had to choose
protect cells after pasting, and further pasting of locked cells are not
protected.
Any help much appreciated



All times are GMT +1. The time now is 04:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com