software

Cells.FormatConditions.Delete
With ActiveCell
.FormatConditions.Add Type:=xlExpression, Formula1:=quot;TRUEquot;
.FormatConditions(1).Interior.ColorIndex = 20
End With

I have the above set up in my worksheet Tab to turn the active cell
light blue.
It works fine but it also seems to disable my Copy/Paste facility.
If I disable the above feature then Copy/Paste is normal.
Any ideas???--
grahammal
------------------------------------------------------------------------
grahammal's Profile: www.excelforum.com/member.php...oamp;userid=20336
View this thread: www.excelforum.com/showthread...hreadid=522204That's one of the side effects of macros. Another is that they sometimes kill
the Edit|undo feature.

I think you'll have to make a choice about which you want.

grahammal wrote:
gt;
gt; Cells.FormatConditions.Delete
gt; With ActiveCell
gt; FormatConditions.Add Type:=xlExpression, Formula1:=quot;TRUEquot;
gt; FormatConditions(1).Interior.ColorIndex = 20
gt; End With
gt;
gt; I have the above set up in my worksheet Tab to turn the active cell
gt; light blue.
gt; It works fine but it also seems to disable my Copy/Paste facility.
gt; If I disable the above feature then Copy/Paste is normal.
gt; Any ideas???
gt;
gt; --
gt; grahammal
gt; ------------------------------------------------------------------------
gt; grahammal's Profile: www.excelforum.com/member.php...oamp;userid=20336
gt; View this thread: www.excelforum.com/showthread...hreadid=522204

--

Dave Peterson