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!

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

  • 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.

    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!