Using VBA how can I hide the same column on all worksheets?

[Armadillos]

Hi all

Please can someone advise how I can hide the same column/s on every worksheet using VBA.

 

[Joe4]

Welcome to the Board!

A simple macro like this should do it:

Sub HideColumns()

    Dim ws As Worksheet
    
    For Each ws In Worksheets
        ws.Columns("D").EntireColumn.Hidden = True
    Next ws
    
End Sub

 

[Armadillos]

Thank you. Works a treat.

 

[Joe4]

You are welcome.
Glad we were able to help!