ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Enable the page area only of a pivot table for protected worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/235522-enable-page-area-only-pivot-table-protected-worksheet.html)

TofTaf 63

Enable the page area only of a pivot table for 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 04:56 AM.

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