Spin control on protected sheet

[tiredofit]

I have an ActiveX spin control on my worksheet which is linked to cell A1.

When I click on the spin control, cell A1 changes value.

If the worksheet is protected and I add this code:

Private Sub SpinButton1_Change()

    Me.Unprotect

End Sub

cell A1 still changes value, as expected.

However, if this code was added instead:

Private Sub SpinButton1_Change()

    Me.Unprotect
    Me.Protect
End Sub

it fails.

Why is that?

I would've thought the code would kick in, unprotect the sheet then protect it again. Stepping into the code works.

 

[GWteB]

It is by Excel's design and the OS's. After all, nothing happens simultaneously but always in a certain order.
In this case btw, the order in which it all happens doesn't have any effect on the result.
Starting with a protected sheet, compare these two scenarios:
Scenario 1:
1. update attempt;
2. unprotect by macro code;
3. protect by macro code.
Scenario 2:
1. unprotect by macro code;
2. protect by macro code.
3. update attempt;

Updating (the value of) the linked cell before running your second macro or afterwards makes no difference, the update attempt will fail due to a protected sheet.