Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
bshbsh
290 Views, 1 Reply

Change occurrence color, then reset it back to how it was before

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?