title: Excel VBA Scroll bar which shift sheet left or right
body: <p>Request: VBA code for mini scroll bar which shift sheet left or right using VBA or ActiveX scroll bar?</p>
  
  <p>I have created a trainer skills matrix which has trainer names listed down the side (in cells 'B7' through 'B86') and Skill disciplines listed along the top (in cells E6 through 'AJ6'). Where the trainers name and a skill intersect I have a dropdown list stating ‘Y’ for has skill, ‘N’ does not skill and ‘n\a’. if the skill is not appropriate for that trainer. I have frozen the header rows (in cells E6 to 'AJ6') and trainer names (in cells 'B7' through 'B86') for easy cross reference</p>
  
  <p>I would like to add a 'mini' horizontal scroll bar (located in cell  A4:B4) which would behaviour exactly like the main excel sheet scroll bar (i.e moving the sheet left or right). I have tried the ActiveX scroll bar and ‘Googled’ solution for over 4hrs with no luck. Could an expert VBA programmer or Excel guru suggest a solution or spost some sample code? Cheers!!</p>
  
  <p><a href="http://i.stack.imgur.com/jVPkM.png" rel="nofollow">Screenshot of my Trainer Skills Matrix</a></p>