Message box to display details of a Pivot Table cell.

[Jason127]

I would like to write a macro to display the details of cell in a pivot table when the cell is double clicked rather than having them come up on a new sheet. I want to keep the workbook locked so other users cannot access the hidden pages. The purpose ids to determine if the value is the sum of multiple values or just a single value.