Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Lv 199 points

Cliff P

Favorite Answers0%
Answers0

  • Excel macro to follow variable hyperlink in a cell?

    The hyperlink below is in a cell (D4) and takes the user to a particular worksheet based on a selected drop-down. I can't find any VBA code that will allow me to follow this variable hyperlink, only static hyperlinks. I don't want the user to have access to the formula, but want to assign it to a button via a macro. Does anyone know the code that can do this?

    =HYPERLINK("[workbook.xls]"&

    VLOOKUP(B4,data!B2:H148,7,)

    &"!A1","GO")

    Thanks,

    3 AnswersSoftware1 decade ago