nikki333
04-27-2019, 04:26 PM
Hi folks
Sorry for asking that many questions, but I'd like to get my project right.
It's only a tiny, but annoying issue...that happens when someone does a modification on one specific sheet, another sheet gets a formatting.
That's desired to happen. The procedure involves some formatting and at last a removal of duplicates from a range within that other sheet.
That's working fine, but the issue is that when I select that other sheet, the range in which the duplicates were removed is still active/highlighted,
although the worksheet_Activate Event of that sheet has code to activate another cell; and indeed the other cell is activated, but still the old range is highlighted...very odd
I was thinking to jump sheets and activate a bit of this and that, but I don't like that as a solution.
Any ideas?
Sorry for asking that many questions, but I'd like to get my project right.
It's only a tiny, but annoying issue...that happens when someone does a modification on one specific sheet, another sheet gets a formatting.
That's desired to happen. The procedure involves some formatting and at last a removal of duplicates from a range within that other sheet.
That's working fine, but the issue is that when I select that other sheet, the range in which the duplicates were removed is still active/highlighted,
although the worksheet_Activate Event of that sheet has code to activate another cell; and indeed the other cell is activated, but still the old range is highlighted...very odd
I was thinking to jump sheets and activate a bit of this and that, but I don't like that as a solution.
Any ideas?