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

Who is Participating?
Martin LissConnect With a Mentor Older than dirtCommented:
Put this in a button or macro.

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

Marty - MVP 2009 to 2012
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

I haven't worked with it at all, but Stephen Lebans has a solution here that
includes support for horizontal scrollbars: is a database containing functions to allow
a user to Set or Get the current position of a ScrollBar Thumb
for a Form.
Looking at your example, it could be as simple as this however - add this code on the CommandClick of the button

ActiveWindow.ScrollColumn = 3 'number of left most column you want to be visible
RayneAuthor Commented:
Thanks everyone :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.