<div>
What version of Excel ?<br />
gowflow
</div>


<div>
Thank you Gowflow - here are the details<br />
<a href="http://blog.sageintelligence.com/excel-tips-tricks/2013/06/protecting-the-pivottable-with-full-slicer-functionality/" rel="ugc">http://blog.sageintelligence.com/excel-tips-tricks/2013/06/protecting-the-pivottable-with-full-slicer-functionality/</a>
</div>


Thank you Gowflow - here are the details
http://blog.sageintelligence.com/excel-tips-tricks/2013/06/protecting-the-pivottable-with-full-slicer-functionality/ [http://blog.sageintelligence.com/excel-tips-tricks/2013/06/protecting-the-pivottable-with-full-slicer-functionality/]

<div>
Tks for your kindness. You should hv awarded the points to yourself as you got the correct answer.<br />
<br />
Pls feel free to post any link to a question you would need help with.<br />
gowflow
</div>


Tks for your kindness. You should hv awarded the points to yourself as you got the correct answer.

Pls feel free to post any link to a question you would need help with.
gowflow

<div>
thank you Gowflow :)<br />
I will ...
</div>


<div>
Hello Gowflow,<br />
<br />
Here is question if you are interested<br />
<a href="https://www.experts-exchange.com/questions/28291518/Pivot-Chart-crtx-within-display-file.html" rel="ugc">https://www.experts-exchange.com/questions/28291518/Pivot-Chart-crtx-within-display-file.html</a>
</div>


Hello Gowflow,

Here is question if you are interested
https://www.experts-exchange.com/questions/28291518/Pivot-Chart-crtx-within-display-file.html [https://www.experts-exchange.com/questions/28291518/Pivot-Chart-crtx-within-display-file.html]

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
Is it possible to protect a worksheet but unprotected the pivot slicers on that worksheet.<br />
&nbsp;A worksheet has 4 pivot tables in it and then there are 10 slicers on that worksheet. What is needed – The worksheet needs to be protected in such a way so that – users can still use the slicers on that worksheet.<br />
How can that are done in VBA?
</div>
</div>


Hello,

Is it possible to protect a worksheet but unprotected the pivot slicers on that worksheet.
 A worksheet has 4 pivot tables in it and then there are 10 slicers on that worksheet. What is needed – The worksheet needs to be protected in such a way so that – users can still use the slicers on that worksheet.
How can that are done in VBA?

vba protect type Pivot

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.