Hi all, I am using a pivot table with Slicers. I have protected the sheet while keeping the Slicer unlocked for functionality.
However, if I keep the Slicer unlocked in a protected sheet then it's able to be deleted by right-clicking.
Is there any way I can prevent/disable delete for Slicer while keeping it functional in a protected sheet?
However, if I keep the Slicer unlocked in a protected sheet then it's able to be deleted by right-clicking.
Is there any way I can prevent/disable delete for Slicer while keeping it functional in a protected sheet?