Keeping Slicer Static

[Biplab1985]

Hello,

I'm looking for a code to keep all the slicers in the worksheet moving/Freezed when the user scroll down the worksheet with mouse or scroll bar.

Thanks!

[Biplab1985]

Any suggestion to start with the code

[Andy Pope]

As with most things on the sheet the only way to keep static is to place in frozen pane area.

With code in the selection event of the worksheet you can reposition the slicers each time a new cell is selected, but that will not stop a user scrolling the slicers out of view.

[Biplab1985]

So there is no alternative way?