Scroll wheel keeps switching to VBA editor

  • Thread starter Thread starter RWN
  • Start date Start date
R

RWN

W2kPro, Office 2k, Logitech Mouse (cordless)

For some time now, and on an erratic basis, if I have the VBA editor active and switch to
the active sheet
then attempt to scroll using the scroll wheel I am immediately taken to the VBA editor.
If I close the editor and attempt to scroll it deactivates the sheet.
I'm forced to close/re-open xl.
I've played with the mouse settings - to no avail.
There doesn't appear to be any logical sequence that would give me a hint other than I've
run whatever macro I'm working on, and even then, it is erratic (sometimes it does
it/sometimes not).

Any clues?
 
I think something similar happened to me. I found out I was in edit [break]
mode on the VBA side (you should be able to tell by looking at the very top
of the screen). If you are, end it, you may get a message about editor will
stop debugging. Click OK or Yes. Hope that helps.
 
You got me closer!
I put a breakpoint in my code and ran the macro.
Upon the break-with the editor active,
I immediately switched back to the worksheet and could scroll to my heart's content.
I switched back to the editor and scrolled then switched back to sheet and attempted to
scroll - "Boom" transferred back to the editor.
Thinking that was it I closed xl, reopened it and tried the procedure again and-guess
what-it worked fine??

I think this is going to be one of those things that I'll never resolve-not a major item,
just a PITA.

Anyway, thanks for your suggestion - it seems related and will give me something to play
with - G*d knows there's probably 10^6 variables that influence it.

Again, thanks.
--
Regards;
Rob
------------------------------------------------------------------------
InchHigh said:
I think something similar happened to me. I found out I was in edit [break]
mode on the VBA side (you should be able to tell by looking at the very top
of the screen). If you are, end it, you may get a message about editor will
stop debugging. Click OK or Yes. Hope that helps.
--
InchHigh


RWN said:
W2kPro, Office 2k, Logitech Mouse (cordless)

For some time now, and on an erratic basis, if I have the VBA editor active and switch to
the active sheet
then attempt to scroll using the scroll wheel I am immediately taken to the VBA editor.
If I close the editor and attempt to scroll it deactivates the sheet.
I'm forced to close/re-open xl.
I've played with the mouse settings - to no avail.
There doesn't appear to be any logical sequence that would give me a hint other than I've
run whatever macro I'm working on, and even then, it is erratic (sometimes it does
it/sometimes not).

Any clues?
Click to expand...
Click to expand...
 
Back
Top