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.

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)

--
Garry

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

On Jan 25, 3:15*pm, GS wrote:
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)

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

pretended :
On Jan 25, 3:15*pm, GS wrote:
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)

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

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.

--
Garry

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