• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Code for Disable Right click on Excel Slicer in Protected Sheet

A

Akash_Patel

New Member
Hello,


My Query

I have an Excel file which has a dashboard and it has multiple slicers which fetch data from one pivot table. All the slicer and Pivot Table are linked with each other. When I have protected my file with the allowance of pivot and filter, All slicers can be still excess by Right click. So that cut, Remove, Change Remote Connection and all other options can be done by selecting Right click on slicer.

Now I don't want to allow the right click on any slicers of my workbook and still the slicers can work as normal. How can I Do it?

Can anyone help me with the code for this.

Thanks
 

Akash_Patel​

As written in many Forum Rules:
  • Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
  • If you do cross-post, please put that in your post.
  • Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

Akash_Patel​

If You read again above text about Cross-Posting
The 1st line something basic.
2nd line ... You seems to missed two times,
3rd line ... should happen ... after ... those previous.

You seems also missed to read and follow
How to get the Best Results at Chandoo.org from

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
Do Yo have a clear image - how could others test Your case? ... without any sample file.

About Your Yes Definitely...
... Have You checked other Forums replies?
 
Last edited:
vletm said:

Akash_Patel​

As written in many Forum Rules:
  • Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
  • If you do cross-post, please put that in your post.
  • Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.
Click to expand...
Yes Definitely, I will post the solution here as well if I will get it. So that it can be useful to others as well.
 
You must log in or register to reply here.
Back
Top