Excel 2007 :: Make Connector Lines Invisible In Some Columns

Using Excel 2007.

I have some connector lines that cross over tables in Columns G:K that are connecting tables in $D to tables in $M

How can I make the part of the connector line in $G:$K invisible?

something like:

Code:
Sub FormatConnector
Dim oConnector as Shape
With oConnector
If .Connector Or .Type = msoLine
If .Connector In Columns($G:$K) Then
.Connector.Segment.Visible = False
End If
End If
End with
End sub