HELP VBA code for auto hiding a certain Column in every tab

[usui]

Hi masters,


I would like to ask a help regarding vba code that can auto hide a certain column in each tab..for example Column C1 = I want to hide all that is under C1..

so basically i have a certain name in row1 that i want to auto hide in each tab

 

[Peter_SSs]

See if you can use something like this. Test with a copy of your workbook.

Sub Hide_Cols()
  Dim ws As Worksheet
  Dim c As Long
  
  For Each ws In Worksheets
    With ws
      For c = 1 To .Cells(1, Columns.Count).End(xlToLeft).Column
        If .Cells(1, c).Value = "abc" Then '<- edit this to your name of interest
          .Columns(c).Hidden = True
        End If
      Next c
    End With
  Next ws
End Sub