Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When I copy a cell in one workbook and want to paste it in an other, I
can't. I suspect one of these commands ruin the operation - any suggestions? Worksheet_Activate() ActiveSheet.Unprotect ActiveSheet.Protect AllowFormattingCells:=False ActiveSheet.EnableSelection = xlUnlockedCells Mindkiller No 2 I try to keep the format i one column, despite past operations. Conditional formatting should be the solution, but I don't succeed. I have a little extra moment - It sholud be one format when the cell in the column to the left has a "K" as value, and an other format if it contains value "I". AND it should keep these formats when copy - paste beteween workbooks. Any sugestions? /Regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy and paste between workbooks | Excel Discussion (Misc queries) | |||
"ignoring" hidden cells in a copy/paste operation | Excel Discussion (Misc queries) | |||
My cut, copy and paste commands are not working when I right clic. | Excel Discussion (Misc queries) | |||
Copy and Paste Between Workbooks | Excel Programming |