SpinUp & SpinDown in Excel 2010
 

Hello,

We recently upgraded our Office suite from 2003 to 2010 and noticed that one of our excel sheets has some issues using the SpinUp and SpinDown.

It works but doesn't refresh automatically. Workbook set to automatic calcs... and i am wondering if it might be the code that is outdated. This is what we are using:

Private Sub spn1_SpinUp()
If Div1Assessment < DIVISION_ASSESSMENT_MAX Then
Div1Assessment = Div1Assessment + 1
End If
End Sub

Private Sub spn1_SpinDown()
If Div1Assessment DIV_ASSESSMENT_MIN Then
Div1Assessment = Div1Assessment - 1
End If
End Sub

Any help is appreciated.

Derick.