title: excel vba Change view of specific split view
body: <p>I use a split screen (vertical) for an excel worksheet. In the left pane I want a menu with buttons (and macro). In the right pane I have named different zone of the worksheet. Clicking on a buttons should show the related zone in the right pane.
  Button is working but only change the view in the left pane.</p>
  
  <pre><code> Sub Vocabulaire()
     ' Vocabulaire Macro
        Application.Windows(2).ScrollColumn = 14
   End Sub
  </code></pre>
  
  <p>Anyone can help?</p>