Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy/Paste
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??? -- grahammal ------------------------------------------------------------------------ grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336 View this thread: http://www.excelforum.com/showthread...hreadid=522204 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy/Paste
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. grahammal wrote: 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??? -- grahammal ------------------------------------------------------------------------ grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336 View this thread: http://www.excelforum.com/showthread...hreadid=522204 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/Paste in Autofilter | Excel Discussion (Misc queries) | |||
copy/paste excel to texteditor -> multi-line text cells gain unwanted double-quotes | Excel Discussion (Misc queries) | |||
ROUNDUP copy/paste and fill handle not working | Excel Worksheet Functions | |||
HELP....Is there a way to automate copy/paste special/transpose - | Excel Worksheet Functions | |||
need to copy/paste formula w/o it changing | Excel Discussion (Misc queries) |