The fear of heights, also known as acrophobia, can be treated with CBT (cognitive behavioral therapy). The following video explains how a fear of a situation (heights) can develop, and how CBT can treat it:
There is an effective self-help book for anxiety, Anxiety Protocol. It is guided by CBT, the most effective treatment for anxiety and fear of heights: