Hi, guys.

My sheet has some buttons, they all open a new workbook. It's the same workbook for all the buttons, but each one has a hyperlink to a different named range in this workbook.

The problem is the workbook asked to open does it in the same window. I need something to open it in a separate window so that I can view the current file and the new file separatedly.

I tried running some macros I found searching the web, linking the buttons to them, but none of them worked.

Any help? Thank you so much.