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.
I am a beginner so please keep in mind I do not know the language terms or where to find most stuff well.
VBA Code:
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