Jim Cone presented the following explanation :
Garry,
"What, exactly, are 'slicers'?"
From the xl2010 help file...
"New in Excel 2010, slicers offer a highly visual way to filter the data in
PivotTables. Once you insert a slicer, you use buttons to quickly segment and
filter the data to display just what you need. In addition, when you apply
more than one filter to your PivotTable, you no longer have to open a list to
see which filters are applied to the data. Instead, it is shown there on the
screen in the slicer. You can make slicers match your workbook formatting and
easily reuse them in other PivotTables, PivotCharts, and cube functions."
Never used them.
'---
Jim Cone
Thanks, Jim! So how does this relate to sheet protection and/or VBA?
(I have not installed 2010 yet...)
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc