ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Blocking specific page cells in a pivot (https://www.excelbanter.com/excel-worksheet-functions/183796-blocking-specific-page-cells-pivot.html)

Hagge

Blocking specific page cells in a pivot
 
Need to create pivottables from a cube where i just want to change one
parameter (user) before publishing a pivot. The User should be as page
selection and fixed. I have tried to block and protect but either it is not
possible to change the other page selections or it is possible to change
everything, including the user. I have found VBA code which could be used but
how do i get the code to run when I open the workbook? Is there an easier way?


All times are GMT +1. The time now is 02:56 PM.

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