Worksheet Scroll Increment
I found Tom Ogilvy's answer on "How to restrict scroll area in Excel
Programming" dated dated 3/23/05 just what I needed in my program. However, I have a remaining issue. The scroll box on my Worksheet is very tiny and when I move it at all it scrolls very rapidly to the bottom of the scroll area. Is the a way to control the increment rate down the Worksheet as the box is moved with macro code? Thanks for your help. Jim |
Worksheet Scroll Increment
Maybe you can reset the used range.
Visit Debra Dalgleish's site for some techniques: http://contextures.com/xlfaqApp.html#Unused jswalsh33 wrote: I found Tom Ogilvy's answer on "How to restrict scroll area in Excel Programming" dated dated 3/23/05 just what I needed in my program. However, I have a remaining issue. The scroll box on my Worksheet is very tiny and when I move it at all it scrolls very rapidly to the bottom of the scroll area. Is the a way to control the increment rate down the Worksheet as the box is moved with macro code? Thanks for your help. Jim -- Dave Peterson |
Worksheet Scroll Increment
Thanks Dave, that solved the problem
Jim "Dave Peterson" wrote: Maybe you can reset the used range. Visit Debra Dalgleish's site for some techniques: http://contextures.com/xlfaqApp.html#Unused jswalsh33 wrote: I found Tom Ogilvy's answer on "How to restrict scroll area in Excel Programming" dated dated 3/23/05 just what I needed in my program. However, I have a remaining issue. The scroll box on my Worksheet is very tiny and when I move it at all it scrolls very rapidly to the bottom of the scroll area. Is the a way to control the increment rate down the Worksheet as the box is moved with macro code? Thanks for your help. Jim -- Dave Peterson |
All times are GMT +1. The time now is 11:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com