Solved

vba protect type Pivot

Posted on 2013-11-08
6
369 Views
Last Modified: 2013-11-11
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?
0
Comment
Question by:Rayne
  • 3
  • 3
6 Comments
 
LVL 29

Expert Comment

by:gowflow
ID: 39634428
What version of Excel ?
gowflow
0
 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
ID: 39634433
If it is Excel 2010 or Up which I don't hv presume when you protect the worksheet you have a set of items amoung them there is
Use Pivot Table Reports and should be something about slicers you should tick both and try if you can access it while the sheet is protected.
gowflow
0
 

Author Comment

by:Rayne
ID: 39634693
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 29

Expert Comment

by:gowflow
ID: 39634774
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
0
 

Author Comment

by:Rayne
ID: 39634797
thank you Gowflow :)
I will ...
0
 

Author Comment

by:Rayne
ID: 39640632
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now