Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy a protected worksheet
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy a protected worksheet
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy a protected worksheet
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 On Thu, 21 May 2009 09:18:09 -0700, cat wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy formula from above cell in protected worksheet | Excel Discussion (Misc queries) | |||
How to disable copy of protected excel worksheet? | Excel Discussion (Misc queries) | |||
allow me to copy and paste in a protected worksheet | New Users to Excel | |||
Copy from Protected worksheet | New Users to Excel | |||
How can I copy/edit a protected worksheet without the password? | Excel Discussion (Misc queries) |