VBA TO CLEAR DATA VALIDATION FROM ALL SHEETS

[JuicyMusic]

Experts, I have googled this and could not find an answer. I also scrolled thru several pages in this site and never came across what I am asking assistance with. Not exactly.

I also have no example VBA to provide. I have a spreadsheet that has 5 to 35 tabs within each month. The column with Data Validation is in column D.
If VBA can can clear all data validation from the whole workbook, that would be great.

Thank you so much<
Juicy

 

[Fluff]

How about

Sub JuicyMusic()
   Dim Ws As Worksheet
   For Each Ws In Worksheets
      On Error Resume Next
      Ws.UsedRange.SpecialCells(xlCellTypeAllValidation).Validation.Delete
      On Error GoTo 0
   Next Ws
End Sub

 

[JuicyMusic]

Again.....Thank you so much. SOLVED!

 

[Fluff]

Glad to help & thanks for the feedback.