View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe[_35_] Joe[_35_] is offline
external usenet poster
 
Posts: 1
Default 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