Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1641
  • Last Modified:

Reset Horizontal Scroll bar to the left (Excel 2007)

Hello All,
I have a question about a vba code : Scrollbar to the left
Clicking on reset button brings the bottom horizontal scrollbar to the very left. How can a vba code be inserted into that reset button so that it does that every time the button is clicked. The reasoning the number is columns is very big and scrolling from right to left at the end of every line is head ache.
Thank you

R
scrollbar.xlsx
0
Rayne
Asked:
Rayne
  • 2
  • 2
  • 2
1 Solution
 
Martin LissRetired ProgrammerCommented:
Put this in a button or macro.

ActiveWindow.ScrollColumn = 1
0
 
RayneAuthor Commented:
thank you MartinLiss
0
 
Martin LissRetired ProgrammerCommented:
You're welcome and I'm glad I was able to help.

Marty - MVP 2009 to 2012
0
Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
xtermieCommented:
I haven't worked with it at all, but Stephen Lebans has a solution here that
includes support for horizontal scrollbars:

http://www.lebans.com/setgetsb.htm
SetGetSB.zip is a database containing functions to allow
a user to Set or Get the current position of a ScrollBar Thumb
for a Form.
0
 
xtermieCommented:
Looking at your example, it could be as simple as this however - add this code on the CommandClick of the button

Worksheets("Sheet1").Activate
ActiveWindow.ScrollColumn = 3 'number of left most column you want to be visible
0
 
RayneAuthor Commented:
Thanks everyone :)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now