Sub FormatMediaProduct()
    Dim ws As Worksheet
    For Each ws In Worksheets
       
        If ws.Name <> ("Product Hierarchy Index") Then
           Sheets(ws.Name).Activate
           UnhideColumns
           HideColumns
    
        End If
    Next ws

    Sheets("Product Hierarchy Index").Activate
    
End Sub

Sub UnhideColumns()
    Columns("A:AX").Select
    Selection.EntireColumn.Hidden = False

End Sub

Sub HideColumns()
'
' HideColumns Macro
' Macro recorded 6/10/2008 by Veronica Boaz
'

'
    Columns("I:AX").Select
    Selection.EntireColumn.Hidden = True
    
End Sub
Thanks for taking a look at this. It's a pretty simple control button... it just hides selected columns.

Veronica