Scrolling w/in worksheet has two speeds??????

DougStroud

Well-known Member
Joined
Aug 16, 2005
Messages
2,966
Scrolling vertically w/in my worksheet I encounter two different speeds, why, and can this be changed?
I am thinking there is something that is in the format of the worksheet that when I am scrolling past this certain area the scrolling slows down considerably and it is in the same area all the time of this worksheet. I have experienced this in other worksheets, but have not found the common thread the causes this effect.

thanks,


ds
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

sunnyland

Well-known Member
Joined
Jan 27, 2006
Messages
912
Hello,

Do you mean the scrolling slow down or doesn't scroll at all.

There is a property scrollarea for each worksheet that defines the scrolling area.

You may know about it already.

Meaning if you wanted to limit where people can navigate on your worksheet you could set ie:

a1:a150

Meaning people couldn't scroll outside these cells.

This property can be set via VBA by selecting the worksheet and them clicking on properties and entering in scrollarea whatever range you want
 

Forum statistics

Threads
1,141,720
Messages
5,708,090
Members
421,546
Latest member
delatollas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top