Restrict Pivot Chart Usage

[rook818]

I posted this on another forum but I'm hoping someone here can help...I'm developing a pivot chart for a team that is VERY bad at tech...I need to do the following but can't figure out how.

• Prevent dragging/deleting/removing alll pivot fields (totals, filters, categories) but still allow setting of filters. (the user just can't drag them off the chart or add new ones)
  
• Prevent all right clicks (i.e. from Totals Fields, data grid, etc)

I do have a good foundation knowledge of VBA but find most coding for pivot charts to be painfully (to say the least).

Anyone have any ideas how to go about this?

 

[mminick]

If you load the properties tab and move to the show/hide tab, it may be possible to remove the Field buttons / Drop Zones check mark. This disallows users from adding or removing items from the chart. There are also several other options under "Allow Users To" at the bottom of the same tab. Included is an allow filtering option that will keep that available. Although I don't know how to keep users from loading the properties and undermining these efforts, it's at least a step in the right direction.

 

[rook818]

Thanks for replying!

I did know about that properties tab but unfortunatly it's not what I'm looking for. I need to have the filters, series, and totals still dispay but be locked into place. The show/hide properties is all or nothing (show or hide, not show and lock).