+ Reply to Thread
Results 1 to 3 of 3

Scroll Bar to scroll columns horizontally

  1. #1
    Registered User
    Join Date
    06-07-2012
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2007
    Posts
    13

    Scroll Bar to scroll columns horizontally

    Hi All-

    I'm making this request because I'm stumped...

    I had a request in my department to add a scroll bar to the top of one of the worksheet to aid folks in not having to go down to the bottom of the page a use the intended scroll bar. Lazy...I know! With that said I thought it could be done rather easily. Well, now I'm not sure where to go. Please help!

    My spreadsheet has the columns frozen from a to J. We need to be able to scroll the remaining columns from K to infinity. I tried a form control scroll bar and an active X scroll bar. Not sure where to put it or how to write the code at this point.

    Thanks in advance!!

    J.R.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Scroll Bar to scroll columns horizontally

    It would be pretty gratuitous to add code to a workbook to duplicate functionality that's already built into the user interface.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    06-07-2012
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Scroll Bar to scroll columns horizontally

    Agreed! Thanks...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1