Prevent right click change on slicer

[nordicdust]

I have a dashbord where everything is protected.
There are some slicers to interact with the dashboard.
I want to prevent the user from deleting, change sorting and connections and all other options one will have with the rigth click.

I have spent most of saturday looking for a way to disable right click on slicers, but it seems there is no solution without getting other problems.

Is there a way to, with Private Sub Workbook_Deactivate(), see if any right click changes have been done ?
Then I can prevent the workbook from been saved with the changes, made from right click.

[nordicdust]

Been looking all over for a solution to this, but no luck.

I se many wright that you can use the:

Please Login or Register  to view this content.

But that does not work on Slicers.

I hope some one can help me solve this.
All help is much appreceated

[alansidman]

Using VBA, you can lock a slicer if the worksheet is protected.

https://docs.microsoft.com/en-us/off....slicer.locked

[nordicdust]

Thanks for taking a look at my problem alansidman,

The lock dos not prevent right click.
I am thinking that I would try something like..
before going to a different sheet, check to se if Slicers exist, if they doen't then Msgbox"some text Bad Boy"
Workbooks("Dashboard.xlsm").Close SaveChanges:=False

Maybe you have a better idear :-)