Protect Workbook/Sheets and Pivot Table

[bemcbride]

So i have this lovely workbook that I need to protect. Simple solution would be just to protect the workbook however when I do that it's disabling the part of my Pivot table that allows you to double click on an item and it gives you all the items on a new sheet.


Now I'm thinking maybe I need to have all the other sheets protected and just have the one with the Pivot table on it disabled.

In addition I have all the formulas on the other sheets protected already.

I just need to figure out a way to allow the used to use the workbook and the pivot table and not allow them to delete anything except for the Pivot Table information sheet that pulls up after double clicking.

I also read about a code that has a password in it but I don't want to use a password because a lot of people will be using it.

I hope this makes sense...

Thanks!!