Killerkris
Board Regular
- Joined
- Aug 6, 2004
- Messages
- 87
Hi
I'm wondering if anyone knows how to disable the data validation input message without losing it and without doing it cell by cell.
I am using the input message as a type of help, but am wanting to turn it off if required. The best solution I could hack together was this (VBA code of course):
Which works, but loses the help, which is not what I want, and selecting 100s of different cells to find those needing it turning off isn't an option realistically
Thanks to anyone who can help[/code]
I'm wondering if anyone knows how to disable the data validation input message without losing it and without doing it cell by cell.
I am using the input message as a type of help, but am wanting to turn it off if required. The best solution I could hack together was this (VBA code of course):
Code:
Cells.Select
With Selection.Validation
.Delete
.Add Type:=xlValidateInputOnly, AlertStyle:=xlValidAlertStop, Operator _
:=xlBetween
.ShowInput = False
End With
Which works, but loses the help, which is not what I want, and selecting 100s of different cells to find those needing it turning off isn't an option realistically
Thanks to anyone who can help[/code]