Here's an example of some macros that can be assigned to a button. It calls up certain saved "Custom Views" (in this case called "All" and "Quantities"). It also shows how to do some filtering - basically these can be simply recorded using the macro recorder.
The two functions "RecordLocation" and "ReturnToLocation" allow the active cell, selection, and visible range to be around the same as before it was called.
Public currentRange As RangePublic TopRow As IntegerPublic TopCol As IntegerPublic currentSelection As RangeSub RecordLocation() Set currentSelection = Selection TopRow = ActiveWindow.VisibleRange.Cells.Row TopCol = ActiveWindow.VisibleRange.Cells.ColumnEnd SubSub ReturnToLocation() currentSelection.Select ActiveWindow.ScrollRow = TopRow ActiveWindow.ScrollColumn = TopColEnd SubSub All()'' All Macro'' RecordLocation ActiveWorkbook.CustomViews("All").Show ReturnToLocationEnd SubSub ShowQuantities()'' ShowQuantities Macro'' RecordLocation ActiveWorkbook.CustomViews("Quantities").Show ReturnToLocationEnd SubSub Baseline1()'' Baseline1 Macro'' ActiveSheet.Range("$A$3:$BE$507").AutoFilter Field:=51, Criteria1:="=1", _ Operator:=xlOr, Criteria2:="="End SubSub Baseline0()'' Baseline0 Macro'' ActiveSheet.Range("$A$3:$BE$507").AutoFilter Field:=51, Criteria1:="=0", _ Operator:=xlOr, Criteria2:="="End Sub