Changing the worksheet scrollbar increment

  • Thread starter Thread starter dave.cuthill
  • Start date Start date
D

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.
 
(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.
Click to expand...

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)
 
(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
Click to expand...

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
 
(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
Click to expand...

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.
 
Back
Top