Changing the worksheet scrollbar increment

[dave.cuthill]

Is it possible to change the behaviour of the scrollbar that allows
the user to scroll widthwise through the columns of the worksheet.
What it am looking to do is change the increment from being one column
per click to something like 12 columns.

 

[GS]

(e-mail address removed) pretended :

Is it possible to change the behaviour of the scrollbar that allows
the user to scroll widthwise through the columns of the worksheet.
What it am looking to do is change the increment from being one column
per click to something like 12 columns.

Do you mean other than pressing PgUp/PgDn keys while holding down the
Alt key? (ergo moving left/right one screen width at a time)

 

[dave.cuthill]

(e-mail address removed) pretended :


Do you mean other than pressing PgUp/PgDn keys while holding down the
Alt key? (ergo moving left/right one screen width at a time)

--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Yes exactly - is this possible to convey in code? Basically reprogram
the scrollbar to function as if the alt key and pgup or pgdn were
being pressed

David

 

[GS]

(e-mail address removed) pretended :

Yes exactly - is this possible to convey in code? Basically reprogram
the scrollbar to function as if the alt key and pgup or pgdn were
being pressed

David

Ok, you can set ActiveWindow.ScrollColumn and/or ActiveWindow.ScrollRow
to a numeric value represent which column/row you want to scroll to the
top left position.