Citroen Berlingo 1.6 HDI (2008), exactly the same symptoms - no horn!
Thanks to my colleagues, after checking the fuses, I used the indicated diagnostic path:
1.Remove the key,
2. Lock the steering wheel
and the horn works - I was not looking for more, but I immediately started to disassemble the steering wheel and I give pictures for posterity:
1 I took off the steering column cover to make it easier to target those holes on the back of the steering wheel

2 I propped the steering wheel with a screwdriver after jumping off the next horns

3 To illustrate, this is what the spring looks like, which you need to "unhook" through these holes

4 Here are the culprits

These contacts on the corners are already bent in the photo, but the material they are made of (some tinplate) is very soft, so it's no wonder that if you hit the horn too much, they bend back and then no longer touch.
Quote: Soco63
In my case, regardless of whether the key was in the ignition switch or not, the horn worked only with the steering wheel locked.