Customize Pivot Table Toolbar

[Guest]

I am using Excel 2000 and I would like to create a customized toolbar for a Pivot Table worksheet which would contain only the available field names (not all of the other pivot table buttons), attach it to that sheet so that when others use this file (I want to limit what the user can do with the pivot table), the customized toolbar is automatically displayed and appears always as "floating" as opposed to docked. I am unclear from the Excel Help how to achieve all of this.

 

[Debra Dalgleish]

AFAIK, you can't customize the PivotTable toolbar. You could create a
new toolbar, with buttons available in the Customize dialog box.

Build the pivot table, and add all the fields that users will need. The
page area can store fields for them to drag into the row or column areas
as required.

Then, restrict the features that are available to users, e.g.:

'==================
Sub LimitPivotTable()
Dim pf As PivotField
With ActiveSheet.PivotTables(1)
.EnableFieldList = False
.EnableFieldDialog = False
.EnableWizard = False
.EnableDrilldown = False
.PivotCache.EnableRefresh = True
For Each pf In .PivotFields
pf.DragToHide = False
Next pf
End With
End Sub
'=======================