Slicer - Disable Context Menu when Right Clicking on Slicer

[ExcelNewbie2010]

Hi All,

I am new to excel 2010 and I just wanted to see if there was any VBA code or point and click method to disable or prevent the context menu from displaying when right clicking on a slicer?



Thanks!

 

[ExcelNewbie2010]

Basically I am looking to create a "dashboard" of sorts for work and I am looking for a way to protect the dashboard worksheet (meaning not selecting charts, not right clicking and preventing people from accidentally deleting things), but still allow the staff to manipulate the data using slicers. I can protect the workbook, but when I uncheck "edit objects" under protect the worksheet, the slicers stop working. Is there any way to protect the workbook from being edited while still allowing someone to click the slicers to manipulate the data?

Any help would be appreciated!