Hi all,
In Sheet1 I have a cell where an Hyperlink links to Sheet2.
I'd like to set the back color of an Activex control button to red in Sheet1, the same where I click on the Hyperlink, right after I click but before control is passed to Sheet2 so that, when I go back to Sheet1, the color of the button is red.
Is there a way to do it by using an event, something like Worksheet_BeforeHyperlink, or maybe someone can suggest a workaround?
Thank you!