Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table protection
I have created a pivot table on a Worksheet, protected
both the Workbook & Worksheet(enabling the Pivot table option)so that the pivot table can be used. The problem is that there are still options available to modify the table. Is there any way to remove these options, allowing only for the normal dropdown page operation. thanking you in anticipation Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
how can I auto refresh pivot table with sheet protection | Excel Discussion (Misc queries) | |||
Sheet protection code conflicts with Pivot Table "auto refresh" | Excel Discussion (Misc queries) | |||
Excel 2002 Pivot Table Protection | Excel Discussion (Misc queries) | |||
Pivot Table Protection | Excel Discussion (Misc queries) |