Search:

Hello.
As part of a macro I am working on, I would like Excel to follow/open a hyperlink to another Excel workbook.

When I CLICK ON THE HYPERLINK in the workbook, I get the warning about making...

Oops, I changed the cell reference, but not the sheet name. It did run after I made the edit, but after clicking OK on the "trustworthy" dialog box, it did the same things as before.

I did find a...

Thanks for taking a look. I tried both variatioins and both returned a Run-time error '9': Subscript out of range.

I am very new to marcos and am having trouble.

As part of a macro I was working on, I wanted to open the hyperlink of a selected cell (contains link to another workbook.)

When I run the macro...