Question: how to add hyperlink in excel macro?
Answer: Excel Dashboards VBA On a cell Lets Say L1 Type the word you want to use. Now right click on L1 and select Link - Insert Link. A Popup will appear after you click on Hyperlink which looks like the following. Choose Place in This Document on the Right, Click on the Sheet the Hyperlink is on and Click OK at the bottom.