+ Reply to Thread
Results 1 to 2 of 2

Scroll bar form control won't stop

  1. #1
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Scroll bar form control won't stop

    Hi all,

    at work, I've created a sheet with a scrollar (form control). Everything was working as planned.
    Now I got home, checked the same sheet to see how it looks like on 1920x1080 and I had to notice that as long the mouse doesnt leave the scrollbar area, the scrollbar increments :/ Has anyone encountered that problem? I did a quick google-session on this one, and I only found a reply that changing the calculation to manual solves this problem. The thing is, with calculation set to manual, the scrollbar is useless :/

    Thanks!
    If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.

  2. #2
    Registered User
    Join Date
    04-29-2012
    Location
    Florida, USA
    MS-Off Ver
    2010, 2013
    Posts
    34

    Re: Scroll bar form control won't stop

    I've had the exact same problem, and spent quite a bit of time (in vain!) trying to figure it out. Other than calculation mode, some have said that this is only a problem in Page Break Preview view and switching back to normal will fix it. This did not work for me either.

    There's even at least one other post about it on this forum, which also went unsolved: http://www.excelforum.com/excel-gene...scrolling.html

    The problem could be that there is extensive recalculation to do every increment of the scroll bar, but that doesn't mean there's a way to get the desired effect. You can't necessarily downsize the calculations, and deleting the scrollbar is no help.

    I eventually gave it up and just worked with what I had, using the mouse off to make the scrolling stop.

+ 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