Forum Discussion
Developer Scroll Bars Suddenly Became Erratic!
Hello,
I have a very unusual problem related to developer form control Scroll Bars! I had previously enjoyed my highly reliable Scroll Bars and Spin Buttons that I had created for months (if not more than a year). Suddenly, (a few days ago) the Scroll Bars are simply no longer reliable, while only the upper button of Spin Buttons is highlighted, even if the lower one is clicked! This occurred without my tweaking!
By unrealiable Scroll Bars I mean you can sometimes slide the scrolls and sometimes not. Usually, the first few work more reliably, while the later ones than freeze! It behaves erratically like that. It can help sliding previous bars and returning to the later ones, zooming in and out, and manually inserting the number and then re-fixing the Scroll Bar. Neither copy/pasting an upper working Scroll Bar, nor inserting a brand new one helps with the erratic behavior!
The same applies to the Spin Buttons. Sometimes, you can click the lower button and the values will go low as expected. However, once the problem settles in, you can continue clicking the lower button, but the upper one will be selected and applied. The same temporary fixes as with the Scroll Bar (and copy/paste and recreation non-solutions) apply!
I have the Excel file ready and wish to upload it here for you to see if you can produce the problem on your end! This has never happened to me before!
Hi, I have the same problem only if using my laptop touchpad (I don't if using the mouse). I've been playing around with ALL touchpad settings (sensitivity and so on), no luck. Besides, if I depress firmly the touchpad (as if it were a mouse single click) then it works ok, but if I just tap the touchpad then it does not (!?).
I cannot see the arrows at the sides of the scroll bar either (https://techcommunity.microsoft.com/t5/excel/scroll-bar-not-showing-arrows/m-p/3582969).
I've done the test on other laptops having less resolution and the problem does not show up.
Were you able to solve your problem?
Ramon.
Sorry for the slow reply. What I have discovered with this issue is that is seems to be more related to the resolution of my second monitor, or the amount of magnification of my document in the window. When the scroll buttons stop working, I can zoom in on the button, and click in the farthest bottom corner of where the up or down arrow would be, and it will start working again. Then I can zoom back out to view the entire document, and it continues to work. The problem also happens when I use my second monitor to view the Excel document. I believe that is because the maximum resolution of my second monitor is lower than that of my laptop. Now, I always move files back to the main monitor before saving them, and it seems to work. If I can't get the scroll bars to work by zooming in on them, I save the document if needed, close it, and re-open it, and the problem goes away until the next time. It's clearly a program error, because I had been using the scroll bars for months without any issue, until the time that I posted asking for help with the issue. Microsoft support was no help with the issue, even when they logged into my computer and saw the issue for themselves.
I hope this helps, and feel free to reach out again if anything I have said requires clarification.
Brian
So, how can I upload the EXCEL file here for you to see?
DDDCi Share it via Onedrive or something similar.
- Hello Riny,
First time I am sending a file with OneDrive, so hope this works:
https://1drv.ms/x/s!AiSSpo9JCdcLgVK2r6ZwhKzh34DX?e=cSvUn2
Try to slide all the bars and click all the Spin Buttons, and you should have the same problem on your end as well!
