SpinButtons Up/Down don't work in a module

I'm trying to have every sheet on my workbook, rows 3 through 25, hide if I click up on the SpinButton, and show if I click down on the SpinButton. But I want to be able to duplicate the spinbutton on each worksheet, while only having to write the code once, in a module. Is this possible?


Right now it doesn't work at all when I put the code in a module or ThisWorkbook, unless I run it from the VB window... which I don't understand. It works when the code is in Sheet1, however.

Here is my code:

Please Login or Register  to view this content.

Thanks!

Thanks - that solved my issues. I avoided using a userform, because I didn't think my users would like dealing with a popup