Want to create a hyperlink to the next open workbook, first sheet. (name is different every time I run a macro)
This code works but for the sheet inside the current (first) workbook but not what Im looking for. I want it to link the first sheet in the next open workbook. I have another one open (second workbook) next to this one. Something with activewindow next ? The link has to be in the first sheet of first workbook.
Thanks!
3f.xlsm
Please Login or Register to view this content.
Bookmarks