Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2007
    Posts
    123
    Thanks
    13
    Thanked 1 Time in 1 Post

    Unwanted 'Vsync' synchronised 2 window scrolling (Excel 2003 SP3)

    Recently for reasons I don't know Excel started an annoying habit.

    I want to look at two windows, showing different parts of the same sheet. I arrange the windows horizontally. Let's say I want the top window to show rows 1-20, and the bottom to show rows 50-70. Before this was no problem. But now, when I try to do this, Excel forces me to view exactly the same rows in each window. On the title bar of the windows it states the file name, the window number, and "[Vsync]". It behaves somewhat as though I've hit the "View windows side by side" option, even though I haven't. I can't seem to turn this Vsync option off, or even find any mention of it under Help. Any ideas? I'd be grateful for any help.

    (By the way, I know that if I only want to see two non-contiguous parts of the same sheet I can simply use 1 window, splitting the screen. I actually want to see three parts of the same sheet, using two windows, one of them split.)

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Unwanted 'Vsync' synchronised 2 window scrolli

    Try running this piece of code and save the workbook (better make a back up just in case)

    Sub SyncOff()
    Windows.Arrange ActiveWorkbook:=True, synchorizontal:=False,
    syncvertical:=False
    End Sub
    Jerry

  3. #3
    2 Star Lounger
    Join Date
    Jan 2007
    Posts
    123
    Thanks
    13
    Thanked 1 Time in 1 Post

    Re: Unwanted 'Vsync' synchronised 2 window scrolli

    Thanks Jerry. Unfortunately for some reason the code doesn't compile. I pasted it injto a new module but the text instantly appeared as red, and when I tried running the code I got a complie error message. Any Ideas what I might have done wrong?
    Lingyai

  4. #4
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Unwanted 'Vsync' synchronised 2 window scrolli

    Whoops, a pesky comma missing <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

    Sub SyncOff()
    Windows.Arrange , ActiveWorkbook:=True, synchorizontal:=False, syncvertical:=False
    End Sub
    Jerry

  5. #5
    2 Star Lounger
    Join Date
    Jan 2007
    Posts
    123
    Thanks
    13
    Thanked 1 Time in 1 Post

    Re: Unwanted 'Vsync' synchronised 2 window scrolli

    Worked like a charm, thanks Jerry

Posting Permissions

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