I have a spreadsheet with a hyperlink bookmark to a separate worksbook. There are several worksheets in the separate workbook that I am navigating back and forth to, so when the user navigates back and forth, it thinks it wants to open it again. Is there a way for Excel to know that the spreadsheet is already open when there's a hyperlink and to stop asking that question? The only solution I see is to have separate spreadsheets, which will be a huge undertaking.
Any help would be appreciated.
Any help would be appreciated.