Showing results for 
Search instead for 
Did you mean: 

How To: Programmatically Scroll Excel

Hey all,

I'm getting more familiar with ActiveX and its use, however I'm stumped on finding a way to do this.  Has anyone ever programmatically scrolled an Excel worksheet?  Maybe I'm looking in the wrong spot...  Would I be able to find how to do this in the Windows API?

Any thoughts/pointers are much appreciated.
0 Kudos
Message 1 of 4
Hi Will
Whenever I am unsure how to do something with Excel in ActiveX, I record a macro in Excel. I then go look at the code in the VBA editor.
Sub Macro1()
' Macro1 Macro
' Macro recorded 15/11/2006 by _
    ActiveWindow.ScrollRow = 27
End Sub
As you can see its possible all you need to do now is translate that to G Smiley Wink
Edit: Grammar

Message Edited by David Crawford on 11-15-2006 05:19 PM

Message 2 of 4
Ahh, thanks very much.

That's a useful piece of advice too.  Wish I'd thought of it 🙂

This will get linked in the Excel thread.

Thanks again David.
Message 3 of 4
And just for reference...

Message Edited by Will.D on 11-16-2006 08:23 AM

Message 4 of 4