R
Roderick Millar
I have written a macro which inserts scrollbars into a
spreadsheet, each one corresponding to a particular cell
(it is for a rota program). This works perfectly well, but
when I try to use the scrollbars I experience a degree of
random slippage. The scrollbar increments the numbers
correctly as I click, and then it zooms ahead. Does anyone
have any idea how to stop this as I know it could become
very frustrating to use.
The only relevant point I can think of is that it began
after I had inserted code to stop automatic calculation
while each sheet was being updated. Or could it be
connected with the fact that the macro deletes all the
scrollbars in the sheet and then puts in new ones?
spreadsheet, each one corresponding to a particular cell
(it is for a rota program). This works perfectly well, but
when I try to use the scrollbars I experience a degree of
random slippage. The scrollbar increments the numbers
correctly as I click, and then it zooms ahead. Does anyone
have any idea how to stop this as I know it could become
very frustrating to use.
The only relevant point I can think of is that it began
after I had inserted code to stop automatic calculation
while each sheet was being updated. Or could it be
connected with the fact that the macro deletes all the
scrollbars in the sheet and then puts in new ones?