What of these commands ruin my copy - paste operation between workbooks?
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
|