Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste 'over' protected cells?
(excel 2002)
I would like to copy a column, and paste 'values' (only) into another col, _except_ I don't want to overwrite a few of the cells in the target col. Protecting those cells blocks the paste operation for the entire col. I'd like the paste to go ahead, and just not do anything to the protected cells. Can I? Thanks, George |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste 'over' protected cells?
When you protect a worksheet, all cells are locked by default, which means
that they cannot be edited. To enable cells to be edited while leaving only some cells locked, you can unlock the cells and then lock only specific cells and ranges before you protect the worksheet. You can also allow specific users to edit specific ranges in a protected worksheet. -- William<"M" "George" wrote: (excel 2002) I would like to copy a column, and paste 'values' (only) into another col, _except_ I don't want to overwrite a few of the cells in the target col. Protecting those cells blocks the paste operation for the entire col. I'd like the paste to go ahead, and just not do anything to the protected cells. Can I? Thanks, George |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste 'over' protected cells?
On Fri, 13 Apr 2007 19:24:02 -0700, Sunday88310
wrote: When you protect a worksheet, all cells are locked by default, which means that they cannot be edited. To enable cells to be edited while leaving only some cells locked, you can unlock the cells and then lock only specific cells and ranges before you protect the worksheet. You can also allow specific users to edit specific ranges in a protected worksheet. I think I knew that. It's not a matter of blocking some users - I'm the only one doing this. There are just some cells that I don't want to overwrite. I'd like to be able to paste a whole column, and have the paste just ignore protected cells. As it is, I get a message that some cells are protected, _and_ the paste operation quits. Maybe you're just saying "no can do"? G |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
paste 'over' protected cells?
Do you want to repeat the same thing over and over? If so, it might make
sense to do this programmatically. You do have to unprotect the sheet before you attempt to work with a range. Let's say you want to paste into column F, you could define a range for column f and do something like this for each r in myrange if not r.locked then 'Copy whatever you want to copy. end if next r I'm not showing all the code you'd need, but am saying that if you're doing the same thing over and over, it might be doable programmatically. Why don't you save your workbook with another name and record what you want to do and paste that macro here if you want assistance. You will have to unprotect the sheet in question and paste the data there, but since this will be a workbook for TESTING, it shouldn't be a problem. SOmeone here can help you clean up the code to do what you want for the protected cells. HTH, Barb Reinhardt "George" wrote: On Fri, 13 Apr 2007 19:24:02 -0700, Sunday88310 wrote: When you protect a worksheet, all cells are locked by default, which means that they cannot be edited. To enable cells to be edited while leaving only some cells locked, you can unlock the cells and then lock only specific cells and ranges before you protect the worksheet. You can also allow specific users to edit specific ranges in a protected worksheet. I think I knew that. It's not a matter of blocking some users - I'm the only one doing this. There are just some cells that I don't want to overwrite. I'd like to be able to paste a whole column, and have the paste just ignore protected cells. As it is, I get a message that some cells are protected, _and_ the paste operation quits. Maybe you're just saying "no can do"? G |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
Can you paste to protected spreadsheet and skip over locked cells? | Excel Discussion (Misc queries) | |||
Copy/Cut/Paste of Merged Cells in Shared Protected Workbooks | Excel Discussion (Misc queries) | |||
how do I cut and paste into a protected worksheet? | Excel Worksheet Functions | |||
how do I cut and paste into a protected worksheet? | Excel Worksheet Functions |