Someone from another forum kindly gave me this code to remove all validation
input messages from a worksheet but it doesn't work or throw any error
messages.
.................................................. ..........................
Sub RemoveValidationInputMsgs()
On Error GoTo None
With
ActiveSheet.UsedRange.SpecialCells(xlCellTypeAllVa lidation).Validation
.InputTitle = Empty
.InputMessage = Empty
End With
None:
On Error GoTo 0
End Sub
.................................................. ..........................
Any help appreciated with this, thanks.