Could any one help me to solve this problem.

On Sheet 2, I create a Pivot Table that consolidates data on Sheet 1. I want to protect Sheet 2 to block the format of the Pivot Table and the un-wanted changes by othe users, but still allow the functions: refresh the data, calculations in the Pivot Table, select and copy data from Pivot Table.

Does Excel 2007 allow to to that without using user-defined VBA/Macro? If not, could you please help me with the VBA code to solve this problem.

Thanks