excel vba Change view of a particular split view

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 another zone of the worksheet. By clicking on a button, the associated zone should be displayed in the right-hand pane.
The button works, but only changes the view in the left pane.

Sub-Vocabulaire ()
# Vocabulaire Macro
Application.Windows (2) .ScrollColumn = 14
End Sub

Can anyone help?