Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying cells in a protected worksheet
Hi,
I have a worksheet in which few of the columns are protected whereas others are unprotected. these protected columns are in between unprotected columns. I would like to copy data from an external souce to this worksheet without unprotecting the sheet. Is it possible. Thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying cells in a protected worksheet
If you copy and paste into just the unprotected ranges, you should be ok.
Rohit wrote: Hi, I have a worksheet in which few of the columns are protected whereas others are unprotected. these protected columns are in between unprotected columns. I would like to copy data from an external souce to this worksheet without unprotecting the sheet. Is it possible. Thanks in advance -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying cells in a protected worksheet
Hi,
Just paste. I suspect you are asking something more complicated than stated, but without the details we can't help. For example are you trying to paste into a range part of which is unprotected and part not, or are you trying to paste a block of data only to the unprotected columns by skipping the protected ones? That is you want to put the copied data into say columns A, D, F with one copy command. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Rohit" wrote: Hi, I have a worksheet in which few of the columns are protected whereas others are unprotected. these protected columns are in between unprotected columns. I would like to copy data from an external souce to this worksheet without unprotecting the sheet. Is it possible. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying formulas into protected cells. | Excel Discussion (Misc queries) | |||
Password protected workbook crashes copying worksheet | Excel Discussion (Misc queries) | |||
Edit text format in non-protected cells in protected worksheet | Excel Discussion (Misc queries) | |||
Copying visible cells only on a protected worksheet | Excel Discussion (Misc queries) | |||
Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions |