ExcelBanter - protect parts of a pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - protect parts of a pivot table (https://www.excelbanter.com/excel-worksheet-functions/151000-protect-parts-pivot-table.html)

angelparadise

protect parts of a pivot table

I have serval worksheets that belong to different departments, each sheet has
a pivot table. I would like to protect each worksheet and parts of the
pivot, so the departments can only see there own data.

All times are GMT +1. The time now is 08:47 PM.