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