Christ is in our midst!!
I think you miss the point of the question.
I did not and am not addressing the question " Can You Baptize Yourself?" but the quote explicitly given:
Theophan is correct: one must possess the Spirit to transmit the Spirit, which is the act of Baptism.
... one must possess the Spirit to transmit the Spirit,...
While I agree totally with the citation from the CCC, the citation assumes that the one doing the baptizing is himself already baptized
Actually, just the opposite:
V. WHO CAN BAPTIZE?
1256 The ordinary ministers of Baptism are the bishop and priest and, in the Latin Church, also the deacon.57 In case of necessity, anyone, even a non-baptized person, with the required intention, can baptize58 , by using the Trinitarian baptismal formula. The intention required is to will to do what the Church does when she baptizes. The Church finds the reason for this possibility in the universal saving will of God and the necessity of Baptism for salvation.59
... In case of necessity, anyone, even a non-baptized person, with the required intention, can baptize...
Put another way: Can I invite myself to Thanksgiving dinner at the White House just because i want to do so? (Let me know how that works next November.)
No need to wait until November, it's a poor analogy for baptism. And actually, regarding inviting, since we no longer enforce the Disciplina arcanii, anyone can attend the Eucharist-Divine Liturgy-Mass, uninvited (save by God's grace) to a thanksgiving (eucharistic) meal.