Rayne
asked on
vba protect type Pivot
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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/
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
Pls feel free to post any link to a question you would need help with.
gowflow
ASKER
thank you Gowflow :)
I will ...
I will ...
ASKER
Hello Gowflow,
Here is question if you are interested
https://www.experts-exchange.com/questions/28291518/Pivot-Chart-crtx-within-display-file.html
Here is question if you are interested
https://www.experts-exchange.com/questions/28291518/Pivot-Chart-crtx-within-display-file.html
gowflow