Message 1 of 2
Change occurrence color, then reset it back to how it was before
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hi,
I'm changing colors (appearances) of occurrences within an interactive vba macro, then when it's done, they need to be changed back (reset) to how they were before.
But the way I do this (storing appearance and appearance source) doesn't work perfectly, as it discards any possible previous overrides. But dealing with overrides is really too awkward just for this.
Unless there's a simple way to achieve this, that I don't know of.
Making temporary design views isn't great either.
Does anyone have any hints or ideas how to do this?