Remove Validation Input Messages
Hi,
It works for me. Note that as written it only works on the active sheet, do
you have the sheet you want it to work on selected?
Mike
"Code Numpty" wrote:
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.
|