The SUBTOTAL function in Excel will subtotal a list and show an outline
control on the left of the screen. The outline control allows the user to
change the amount of data shown in the sheet (data with subtotals, only
subtotals or only grand total). Can this outline control be programmed via
VBA? I would like to have a list that only shows the subtotals (without the
source data displayed)? Will I have to switch to a Pivot Table to
accomplish this task?

Thanks