Slicer.Locked property (Excel)
Returns or sets whether the specified slicer can be modified when the sheet that contains it is protected. Read/write.
Syntax
expression.Locked
expression A variable that represents a Slicer object.
Return value
Boolean
Remarks
True if the slicer is locked when the sheet is protected. False if the slicer can be modified when the sheet is protected. The default value is True.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.