Forum Discussion
Developer Scroll Bars Suddenly Became Erratic!
Good thing they made it across!
These sliders and spin buttons are a part of another Excel file where they matter. I have removed all the other information because they are sensitive. I am hopping that if we can find a solution to fix this part of that Excel file, that I can then fix that other original file.
Basically, I just want all the sliders and spin buttons to work on the attached file. Have you tried them all until the last one in the end? Do all of them work on your end?
I have separated them in color so as to differentiate which works and which does not. Usually, as I click all the buttons and sliders, as I go down by the green slider, it does not work! It will require some strange tweaking (zoom in/out) before it would work!
DDDCi I can push and slide the buttons and numbers change. What is the erratic behavour I'm supposed to notice?
- On all of them?
DDDCi Please understand that I'm not going to click on each and every button until I know what I'm supposed to be looking for.
- Yes, of course. Sorry, I am new at this!
What should appear also at your end is sliding bar and spin button erratic behavior. Normally, you would expect numbers assigned to each sliding bar and spin button that are positioned to the left (all three sets) to change on command. On the attached Excel file, this does not occur, hence "erratic behavior."
So, if you were to test whether the numbers change as demanded (i.e., move slider to left or right and the numbers change as arranged, or click the lower spin button and the numbers should go to the extremes) on all the sliders and spin buttons, then I expect that you would see that not only do not all of them work, but they do not work all the time neither! So, sometimes the first few sliders will work, and the bottom ones would not. Then, the bottom ones would not work, the upper ones will! Or, no matter if you click the lower spin button, the upper one will be activated, and so on!
Temporarily "fixing" this is is done by zooming in or out, of all other "solutions!" What on earth does zooming has to do with this problem?
Alternatively, perhaps you can slide all the sliders and all spin buttons (upper and lower) work at your end reliably? In such a case, the problem would then be local, which is even more challenging!