Forum Discussion
Custom VIews--menu selection is grayed out-
If you have data in a Table on any worksheet, then the Custom Views is not available.
mathetes you can't hide columns with filter though. A macro that hides columns and creates a view is very quick and easy to make or use/adapt these,
Sub hidecols()
'
' will hide columns of active worksheet listed in the first range line below
'
Range("D:D,E:E,F:F,G:G,H:H,J:J,K:K,L:L,N:N,U:V,X:AA,AH:AJ").Select
Selection.EntireColumn.Hidden = True
End Sub
Sub unhideallcolumns()
'
' unhideallcolumns Macro
' selects all cols of current worksheet and unhides them.
Columns("A:XFD").Select
Selection.EntireColumn.Hidden = False
End Sub
To create views with particular rows visible or hidden there's now a built in feature called sheetview on the view menu. That said with macro's you can create views based on hiding columns and selecting/hiding certain rows.
