I am trying to ensure that multi select is enabled on my slicers when a workbook is opened.
The following VBA selects my slicer, but its not enabling multi select, in fact I noticed that my num lock is now toggled off.
Private Sub Workbook_Open()
ActiveSheet.Shapes.Range(Array("Slicer")).Select
Application.SendKeys "%s"
End Sub
The following VBA selects my slicer, but its not enabling multi select, in fact I noticed that my num lock is now toggled off.
Private Sub Workbook_Open()
ActiveSheet.Shapes.Range(Array("Slicer")).Select
Application.SendKeys "%s"
End Sub