Mouse scrolling does not work (VBA?)

[realred2]

I've had this happen before, and not sure how it was fixed, but I am unable to use the mouse wheel to scroll on the pages of all the spreadsheets I use currently that have VBA in them. If I open a brand new spreadsheet, it scrolls with the mouse wheel just fine. I did a quick (') of each VBA line in the file I'm working on, and it did not fix it. I don't have scroll lock on, no freeze panes. It's terribly annoying. Any suggestions on what else to look at? I think it happened when I copied a workbook page from one workbook to another. Thanks!

 

[My Aswer Is This]

Show us all the code you have on those sheets where you have the scroll problem.
I suspect you have some Vba script or scripts which run automatically when you perform a certain task. Like sheet change event scripts.

 

[realred2]

'Private Sub Worksheet_Change(ByVal Target As Range)

'Dim LstRw As Long, Rw As Long
'Application.ScreenUpdating = False

'''Un-hide all rows to start with
'Range("C8:C156").EntireRow.Hidden = False



'For Rw = 4 To 156
'  If Cells(Rw, 6) = "ELL" Then Cells(Rw, 6).EntireRow.Hidden = True
'Next Rw

'Application.ScreenUpdating = True

'End Sub

'Private Sub Worksheet_Change(ByVal Target As Range)

'Dim LstRw As Long, Rw As Long
'Application.ScreenUpdating = False

'''Un-hide all rows to start with
'Range("C8:C158").EntireRow.Hidden = False



'For Rw = 4 To 158
'  If Cells(Rw, 6) = "ELL" Then Cells(Rw, 6).EntireRow.Hidden = True
'Next Rw

'Application.ScreenUpdating = True

'End Sub

This is all the VBA I have on any of the pages in the file. The VBA Project tree shows as follows:

VBAProject (01 VOLTAGE DROP.xlsb) - My workbook file​

.....Microsoft Excel Objects​

...........Sheet14 (NAC PANEL 1 (7 CKT)) - Has the second VBA code group in it​

...........Sheet4 (LOOKUP) - Nothing VBA here​

...........Sheet7 (FIRE ALARM CONTROL PANEL) - Has the first VBA code group in it​

...........ThisWorkbook - Nothing VBA in here​

VBAProject (PERSONAL.XLSB) - No Idea where this is or came from​

.....Microsoft Excel Objects​

...........Sheet1 (Sheet1) - Nothing VBA here​

...........ThisWorkbook - Nothing VBA in here​

I have no idea how to remove the Personal.xlsb stuff from the tree or file. There are several hidden pages with nothing else, and as you can see the VBA has been quoted out, so is not even being used.
Thanks, Anything else you need let me know.

(Edit for formatting)

 

[My Aswer Is This]

Sounds like you have no Vba code in the workbook.

Why do you have all this code but have it as you said:
the VBA has been quoted out?

So not sure what to tell you.
But then say:
Sheet14 (NAC PANEL 1 (7 CKT)) - Has the second VBA code group in it
What does this code look like?

 

[realred2]

Sounds like you have no Vba code in the workbook.

Why do you have all this code but have it as you said:
the VBA has been quoted out?

So not sure what to tell you.
But then say:
Sheet14 (NAC PANEL 1 (7 CKT)) - Has the second VBA code group in it
What does this code look like?

The second block of vba above. I took it all out to try and clear the issue, no luck. Same as when it was active.

 

[My Aswer Is This]

The second block of vba above. I took it all out to try and clear the issue, no luck. Same as when it was active.

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.

 

[netanel99]

It happens to me a lot, it usually because I have multiple excel files open, and in some excel file I've clicked on a text box,
In order to fix it I just click on that excel file and click somewhere else not on the text box, then return to the excel I want to work on and the scroll is now available

 

[realred2]

It happens to me a lot, it usually because I have multiple excel files open, and in some excel file I've clicked on a text box,
In order to fix it I just click on that excel file and click somewhere else not on the text box, then return to the excel I want to work on and the scroll is now available

I usually only have one workbook open at a time, and only the spreadsheet, no text boxes (unless you mean a standard square (like A1).

 

[netanel99]

Well, for me it's something to do with just bug that cause the scroll to be occupied in some other activity and returning to it and click on something else free it, so I guess there'r a lot of causes of this and it'll be worthy to try it in your case, because I don't know what might cause it with your regular usage.