Copy/Paste

G

grahammal

Cells.FormatConditions.Delete
With ActiveCell
..FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
..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???
 
D

Dave Peterson

That'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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top