At some point up the cable, the two terms (downward gravity and upward centrifugal force) equal each other; objects fixed to the cable there have no weight on the cable.
At some point up the cable, the two terms (downward gravity and upward centrifugal force) are equal and opposite. Objects fixed to the cable at that point put no weight on the cable.