PDA

View Full Version : How to set no. of line per scroll for different worksheet



WWII
05-20-2006, 09:04 AM
Hi,

I have sheet 1 to sheet 5, is it possible to use some code to set the no. of lines to scroll per sheet without changing my mouse setting?


eg. I want to scroll 8 lines/scroll for sheet 1, 10 lines for sheet 2, etc,

Cyberdude
05-21-2006, 12:28 PM
Hi, WWII! Welcome to VBAX!

I don't quite understand what your needs are.

Do you want to set the mouse scroll so that whereever you are poiinting, when you move the wheel you will skip over, say, 10 lines?
-OR-
Are you trying to move to specific spots on the worksheet in the quickest possible manner?

WWII
05-23-2006, 10:48 AM
Yes, I just want to set the mouse scroll so that whereever I am pointing, when i move the wheel, it will move down/up 10 lines per scroll for sheet 1, and 5 lines per scroll for sheet 2 etc, different sheet have different scroll lines,
Or is it possible to set the mouse to move to a specific cell area to get this scroll activated?

How to do this?

I know how to move to a desire spot by using a macro recording,

Thanks fo any expert help,