View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cat Cat is offline
external usenet poster
 
Posts: 63
Default copy a protected worksheet

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.

"Eduardo" wrote:

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.