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 |
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 |
All times are GMT +1. The time now is 07:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com