title: scroll a page up and down and across specific range
body: <p>I have a worksheet with multiple command buttons / shapes assigned to macros that my users can click on to perform certain  actions. However, I want this worksheet to look a  bit more "professional" like a dashboard so I would need to be able to show all these buttons on the top left hand side corner of the first page (say in column A). </p>
  
  <p>The problem is that my worksheet is several pages long and when I scroll down, the buttons disappear too as they stay on the first page. </p>
  
  <p>I know I can freeze the first page but it doesn't look right because I have too many buttons to fit in the first couple of rows. For example doesn't look user friendly to freeze the first 10 rows, hence I want to have all these button on the top left hand side corner of the first page. </p>
  
  <p>I've come up with the following code to allow the user to scroll but it doesn't seem to work: </p>
  
  <pre><code>Private Sub Worksheet_SelectionChange(ByVal Target As Range)
      Worksheets("dummy").ScrollArea = "B1:AA5000"
  End Sub
  </code></pre>
  
  <p>Your help is much appreciated and any questions then please let me know.    </p>