var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: VBA Restrict Pivot Chart Usage
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)
Anyone have any ideas how to go about this?