ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Enable page area of pivot table on protected worksheet (https://www.excelbanter.com/excel-programming/430568-enable-page-area-pivot-table-protected-worksheet.html)

TofTaf 63

Enable page area of pivot table on protected worksheet
 

Hello All,

I want to protect a worksheet containing a pivot table but I would like to
allow the users to have access to the drop down list of the elements
contained in the page area of the pivot table.

Would anyone know if there is an easy way to do that?

Thanks.
--

Regards, TofTaf 63.





All times are GMT +1. The time now is 10:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com