Workbook keeps opening to the wrong scrollrow

    When opening the workbook, the "menu" tab should not scroll to a row below, but it keeps doing that.


    I'm almost certain that the below block of code is causing the issue. What is stranger is that when creating another workbook, I couldn't replicate this error. I would be open to workarounds, but I like the format I'm working with.


    Thanks guys!


    Code
    Private Sub ComboBox1_Change()
     
    ActiveWindow.ScrollRow = Worksheets("control.fullDataSet").Range("fullDataSet.jumpToRow")




End Sub

    forum.ozgrid.com/index.php?attachment/72723/

    Re: Workbook keeps opening to the wrong scrollrow


    I would assume that it's because you bound the control to the range directly. When the workbook opens, the control is reloaded, which triggers its change event.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login