Jumpy Scrolling

  • Thread starter Thread starter Duane Dibble
  • Start date Start date
D

Duane Dibble

Greetings all,

I have a small issue that has not become a personal crusade. I am
using Excel 2000.

As I scroll down with the arrow key, when I get to the bottom row of
the screen, rather than simplying moving 1 cell down and pushing the
top row off of the top of the screen, my application re-centers the
cursor on the screen and immediately moves the top half of the rows on
the screen off of the screen and shows the equivalent number of rows
going forward on the bottom of the screen.

It gets kind of annoying after a while. I simply want it to move 1
row at a time and keep the cursor on the bottom of the screen. I'm on
a network and it appears that my machine is the only one affected.
Last week everything worked fine and I could scroll smoothly through
my spreadsheets without 'jumping' to the center of the screen.

This action happens on all spreadsheets I open on my machine. When
other people open a spreadheet I've created, this 'jumping' does not
happen to them, but it still happens on my machine. I have not
installed any new add-ins and there is no code behind the sheet that
might be causing this.

Has anyone had this happen to them? Any help would be greatly
appreciated. Thanks in advance.
 
Have you been playing with application events? Or did you set up a workbook to
run each time you open excel (like in Tools|addins or in your XLStart folder)?

Since it happens on all your workbooks and only on your pc, I'm guessing that
there is a "helpful" event that's running in the background waiting for you to
get near that edge.

Try opening excel in Safe mode.
Close excel
Windows start button
Excel /safe

Does it still happen? If it does, then ignore the rest of this message--I got
no answer!

But if it doesn't, close excel and reopen it normally.

Take a look at tools|Addins to see if you have anything unusual loaded--look at
your co-workers for comparison.

If no difference, then take a look at your XLStart folder and see if there's a
new workbook there. You can use windows Start button|find to search for XLStart
(the location varies with versions of windows and excel).

If you see a workbook named: EventWorkbookToCenterSelectedCell.xla, you might
have found it <vbg>.

You may want to compare the contents of your XLStart with your co-workers, too.
 
Back
Top