+ Reply to Thread
Results 1 to 8 of 8

Scroll Into View

  1. #1
    Registered User
    Join Date
    01-04-2013
    Location
    Derby, England
    MS-Off Ver
    Excel 2003
    Posts
    64

    Scroll Into View

    Hello,

    I put up a thread a few weeks ago for some help on one of my woorkbooks.

    Someone kindly gave me a code which worked but unfortunately it will not work in the new workbook.

    The code he gave me was;

    Please Login or Register  to view this content.
    What I am trying to achieve is for the screen to follow the flowchart. So that each time that I press next, the workbook scrolls down so that I can see the next step/shape without having to manually scroll.

    I have attached the document so that you can see what I mean.

    Many thanks in advance!
    Attached Files Attached Files

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Scroll Into View

    That code doesn't appear to be in the workbook.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    01-04-2013
    Location
    Derby, England
    MS-Off Ver
    Excel 2003
    Posts
    64

    Re: Scroll Into View

    No, I took that code out as it wasn't working. I tried it in several locations within the code & it didn't work.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Scroll Into View

    If code doesn't work it's not always a good idea to remove it, kind of makes it hard to find out why it isn't working.

    How wasn't it working anyway?

  5. #5
    Registered User
    Join Date
    01-04-2013
    Location
    Derby, England
    MS-Off Ver
    Excel 2003
    Posts
    64

    Re: Scroll Into View

    The reason I took it out is because I tried it in many many different places.

    I press start and the first shape appears, then the idea is to press next as you go through the flowchart, what I want this code to do is scroll down the page so that the next shape/step is always in view.

  6. #6
    Registered User
    Join Date
    01-04-2013
    Location
    Derby, England
    MS-Off Ver
    Excel 2003
    Posts
    64

    Unhappy Scroll Into View

    Hi there,

    I'm still having this problem, can anyone help me with a solution? Please see updated attachment.

    Thank you!
    Attached Files Attached Files

  7. #7
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,430

    Re: Scroll Into View

    try the following

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  8. #8
    Registered User
    Join Date
    01-04-2013
    Location
    Derby, England
    MS-Off Ver
    Excel 2003
    Posts
    64

    Re: Scroll Into View

    Hi Andy,

    Thank you so much, it works a treat!

    Kate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Getting column to scroll with view
    By lmsmith in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-11-2010, 09:50 PM
  2. Locking rows so they don't scroll out of view
    By abdigital in forum Excel General
    Replies: 2
    Last Post: 12-02-2009, 04:05 AM
  3. [SOLVED] Column Headings Scroll out of view
    By Grd in forum Excel General
    Replies: 1
    Last Post: 07-05-2005, 03:05 PM
  4. [SOLVED] Scroll the screen view with the scroll bar
    By avbs in forum Excel General
    Replies: 1
    Last Post: 06-25-2005, 12:05 PM
  5. Possible to view spreadsheets without scroll bars?
    By londonchick in forum Excel General
    Replies: 3
    Last Post: 06-23-2005, 07:05 PM

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