CCC 65 “In many and various ways God spoke of old to our fathers by the prophets, but in these last days he has spoken to us by a Son.”1 Christ, the Son of God made man, is the Father’s one, perfect and unsurpassable Word. In him he has said everything; there will be no other word than this one. St. John of the Cross, among others, commented strikingly on Hebrews 1:1-2:
In giving us his Son, his only Word (for he possesses no other), he spoke everything to us at once in this sole Word – and he has no more to say. .. because what he spoke before to the prophets in parts, he has now spoken all at once by giving us the All Who is His Son. Any person questioning God or desiring some vision or revelation would be guilty not only of foolish behavior but also of offending him, by not fixing his eyes entirely upon Christ and by living with the desire for some other novelty.
2

CCC 66 “The Christian economy, therefore, since it is the new and definitive Covenant, will never pass away; and no new public revelation is to be expected before the glorious manifestation of our Lord Jesus Christ.”3 Yet even if Revelation is already complete, it has not been made completely explicit; it remains for Christian faith gradually to grasp its full significance over the course of the centuries.

CCC 67 Throughout the ages, there have been so-called “private” revelations, some of which have been recognized by the authority of the Church. They do not belong, however, to the deposit of faith. It is not their role to improve or complete Christ’s definitive Revelation, but to help live more fully by it in a certain period of history. Guided by the Magisterium of the Church, the sensus fidelium knows how to discern and welcome in these revelations whatever constitutes an authentic call of Christ or his saints to the Church.
Christian faith cannot accept “revelations” that claim to surpass or correct the Revelation of which Christ is the fulfillment, as is the case in certain non-Christian religions and also in certain recent sects which base themselves on such “revelations”.

1 Heb 1:1-2.
2 St. John of the Cross, The Ascent of Mount Carmel 2,22,3-5 in The Collected Works of St. John of the Cross, tr. K. Kavanaugh, OCD, and O. Rodriguez, OCD (Washington DC:Institute of Carmelite Studies, 1979),179-180:LH, OR Advent, week 2, Mon.
3 DV 4; cf. 1 Tim 6:14; Titus 2:13.