Making header appear at a certain point on site

You can do it if you don’t use a real header but a container (strip/box) instead.
But how to do it depends on how exactly you want it to behave (and on whether or not you’re using EditorX).
Your question doesn’t include enough info.