Could you please help me to include a command to a hyperlink. I want to update a cell value in another sheet when hyperlink is clicked. I have the code for hyperlink directing to website (mentioned below). Is there a way to modify this code so that when hyperlink is clicked, a cell value in another sheet is updated.
Code I have:
ActiveSheet.Hyperlinks.Add Range("E2"), Address:="https://www.automateexcel.com/", TextToDisplay:="Issue", ScreenTip:="Issue Stationary to Request Owner"