In Tuesday’s post, I showed how WingDings and other symbolic fonts can be used on slicers for an interesting effect.
But there was a lot of manual work involved with changing slicer style settings in order to accomplish that – eight repetitive steps.
I’m back today to share a macro that makes that process much more painless.
I’d Like to Thank the Academy… of Macro Recording
I’ve said it before and I’ll say it forever – the ability to record macros in Excel is the single greatest reference on how to write macros of your own. And I leaned heavily on that recording feature to write what I’m sharing here.
So even if you’re not a macro person, I recommend trying out macro recording. There’s some “how to” info at the end of a post from March.