CODEWITHSUNDEEP
excelvbamousewheel
tea_pea
tea_pea

Reputation: 1542

Excel Middle mouse button click not scrolling

I have a workbook that will not let me glide around by clicking and holding the middle mouse button.

I've seen a lot of answers and help around basic scrolling with the mouse, but that's working fine in this case. It's when I hold down the button, nothing happens. It works on other spreadsheets I have open at the same time so the problem must be specifically with that workbook.

I seem to remember having the same trouble long ago with a single sheet in a book.

Any ideas? The workbook does have a lot of VBA, but I've been unable to detect any part which would affect this. Could there be something buried in that?

Upvotes: 0

Views: 3945

Answers (2)

Adam Portmann
Adam Portmann

Reputation: 1

I found that if I have hidden columns the middle-mouse click does not work, as mentioned by tea_pea. However, if I unhide them and then re-hide them the middle-mouse click works still works. I didn't have to keep the right-most column unhidden.

Using Office365

Upvotes: 0

tea_pea
tea_pea

Reputation: 1542

aha, someone at work figured it out. It happens when you've hidden columns all the way to the end of the sheet. I've unhidden them and am gliding around easy again.

Upvotes: 1

Related Questions