Help with applying this macro to the whole workbook

Hi there excel experts

Please help me with changing of one macro.

Sub clear_zero()
      Dim rng1 As Range
Set rng1 = Columns(2)
With rng1
    .AutoFilter 1, "0"
    With rng1.Offset
        .ClearContents
        .ClearComments
    End With
End With

End Sub

This macro is clearing zero values of column number 2.
It is working only on active worksheet. It should work on every worksheet in the wrokbook.

Thanks for the help!