Run time error 1004: Unable to set hidden property of range class

[SAVIOBLUEFOX]

Hi there,

I am completely new to VBA coding on Excel (just living off tit-bits from the net) and would need some help.

Have a sheet wherein BW2 is an Option Button when clicked hides or opens AK: BV. All works fine as long as sheet is unprotected.

However once sheet is protected, the Option buttons dont function thereby throwng up the error as listed on the subject line.

Would need some guidance on this please.

Sub OptionButton12_Click()
    With Columns("AK:BV")
        .Select
       .EntireColumn.Hidden = Not .EntireColumn.Hidden
    End With
End Sub

Thanks,
Saviobluefox