Molly,
I had the same drama with my sedan one, but was lucky enough to have a spare one to replace it with.
Looking at the one I pulled out, they are not too easy to retighten. Some things you could try:
a) undo the three roof screws and pull it out of the car (so you don't slip with a screwdriver and put it through the headlining
). Remove the slot-head tightening bolt and put a few drops of oil on the bolt threads and under the bolt head (this will let the bolt tighten up more before friction makes it unturnable). Use a screwdriver that fits the bolt head well, as with a small screwdriver the mild steel bolt tends to burr the head. Try tightening the screw now that you can get a decent angle/force on it.
b) use a pair of mulitgrips (wrapped in a rag) to squueeeeeeeze the chrome bracket assembly together whilst a helper tightens the bolt.
c) the sunvisor arm assembly has a ball at the end of it, and appears to be hard to get out. You could try removing the slot-head retaining bolt, spreading the chrome bracket (gently, without cracking the chrome off it
) then taking out the arm assembly. Roughen it up with some sandpaper, or wrap it in a layer of tape (to give it more grab) before putting it back in (again without cracking the chrome). Don't like the chances of getting that arm out though.
d) left-field, last resort and rather dodgy idea... with the sunvisor removed, try putting a small amount of glue (woodglue or Tarzan's grip... not aryldite or superglue which may work too well) into the area where the sunvisor turns. The glue won't stick, but it may provide enough friction to help prevent the sunvisor turning (kind of like the reverse of using WD40).
Lets us know how you go.
Cheers,
Harv.