At the total union level? The individual nations get no say?
That is how the referendum worked. If the individual nations want out, there is a process for that (with, of course, NI now also needing Ireland to want them).