Public Function DeleteAllSlicersFromWorkbook( _
wb As Workbook _
ws As Worksheet, _
shp As Shape
For Each ws In wb.Sheets
For Each shp In ws.Shapes
If shp.Type = msoSlicer Then shp.Delete
Your email address will not be published. Required fields are marked *
Save my name, email, and website in this browser for the next time I comment.
Notify me of follow-up comments by email.
Notify me of new posts by email.