Macro not working on protected sheet

[WindowGuy]

Hi all. I am using this amazing Macro below. Thanks to user Fluff. I can not however get it to work once sheet protected.... Anyone know how to make that work?
I am a beginner so please keep in mind I do not know the language terms or where to find most stuff well.

Sub DropDownListToDefault()
   Dim Rng As Range
   
   Application.ScreenUpdating = False
   On Error Resume Next
   Set Rng = ActiveSheet.UsedRange.SpecialCells(xlCellTypeAllValidation)
   Rng.Value = "'- Choose Option -"
   On Error GoTo 0
End Sub

 

[WindowGuy]

so i found the answer... this youtube video did it for me.

Using Macro in Protected Sheet

George

 

[SunnyAlv]

Sub DropDownList ()

ActiveSheet.Unprotect Password:="UR Pass to Protect Sheet" 'To Unprotect ur Sheet


'UR CODE Heree


ActiveSheet.Protect Password:="Ur Pass Protect Sheet" ' To Protect ur Sheet Again



End Sub