I create repeatable reports where many slicers are used. The format calls for the slicer right and left edges to be butted up to one another, aligned top, same height. I current have to select all and distributed horizontally and adjust from there, seems fastest. The trick doing it that way is approximating the location of the left and right slicer, then manually adjust from there to make the right and left edges of the slicers meet. Placing them one at a time using snap to object is cumbersome too.
I would like to create a macro that would select all the slicers, align by top, then snap the left edge of subsequent slicers to the right edge of the previous, distributing them to the right. I know it is possible and have seen other programs that do it, but don't know where to begin. Any help is greatly appreciated.
(example attached)
Thanks,
Dave
Bookmarks