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" wrote:

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.