Menu

Changing the worksheet scrollbar increment

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to microsoft.public.excel.programming

GS[_2_]

GS[_2_] is offline

external usenet poster

Posts: 3,514

Default

Changing the worksheet scrollbar increment

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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Scrollbar changing dollars	Doug	Excel Programming	3	October 3rd 08 07:50 PM
Linking Scrollbar Min and Max values to worksheet cells	greg235	Excel Programming	1	August 1st 07 02:40 AM
Scrolling the Worksheet with the scrollbar	Fred Holmes	Excel Discussion (Misc queries)	3	August 16th 05 10:32 PM
scrollbar reslut makes another scrollbar to show	Patrik	Excel Discussion (Misc queries)	0	April 18th 05 03:11 PM
Changing a scrollbar value to 0	Nilrem[_3_]	Excel Programming	1	November 14th 03 08:14 AM

All times are GMT +1. The time now is 11:08 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement