Forum Discussion
Solved
Disabling and re enabling Spinners controls in 2010 and setting the count back to zero.
Hi all, I am novice with anything to do with excel, most self taught. Right my question is, can a a non Active X control spinner be disabled and then reactivated and the count reset to zero. I a...
See the attached version. It is now a macro-enabled workbook, so you'll have to allow macros when you open it.
To inspect the code, right-click the sheet tab and select 'View Code' from the context menu.
I'd have to see the workbook...
Turns out that your first code was right, as when I put it back to that in my new version all started to work, as the first spinner starts at number is 2.