Pivot table functions disabled when workseet is protected. Workaround? VBA to sort?

Good morning. I have a Workbook that includes Pivot Tables and formulas for totaling columns. I would like to protect the worksheets so the user is unable to alter or delete rows that contain formulas. When I protected the worksheet the Pivot Tables would no loner work. I need the user to be able to sort the tables by each column, as they see fit.

Is this possible using Pivot Tables or am I going to have to migrate to using VBA code to sort in my protected workbook? Thanks.

Matthew

If the pivots are on the same sheet as the source, then you will need VBA to unprotect the sheet and take the necessary actions on the source or the pivots. If the pivots are on a separate sheet, then the source can stay locked and the pivot sheet can be unprotected...

To view code for unprotecting sheets/pivots, see here: http://www.contextures.com/xlPivot12.html#sheet