copy a protected worksheet

[cat]

We are trying to protect a boilerplate worksheet however, be able to
copy/paste certain columns to a new sheet without someone having the ability
to manipulate the numbers.

 

[Eduardo]

Hi,
if the columns to be copied and paste are the ones where the user enter the
information you need to unprotect that cell before protecting the sheet,
right click in the mouse format cell protection , unchek locked, otherwise
you need to unprotect the workbook in orden to be able to copy that columns

if this helped please click yes, thanks

 

[cat]

Thanks, I was looking for away that the person working on this template could
just freeze the info in the columns and then paste the columns in other
workbooks when needed w/o the process of unprotecting then protecting. This
may be our only solution. Thanks again.

 

[jambun]

Why not make a macro that unlocks the columns, copies the information
and then relocks the columns. The information should then be held in
memory to paste to where you want it to go. Or within the macro you
can automaticaly tell it where to go. Place the macro button at the
top of the column.
EPJ