Link Opening in New Window (Excel 97)

[daph]

Hi everyone,

Small question: I added some web links in an Excel document. When I click on them, I have to click BACK to return to my Excel document. (Closing the web document will close my excel document). I know that I can open the link in a new window by right-clicking and choosing the option Hyperlink -> Open in New Window.

My question is: Is there a way to have it changed so, by default, it will always open in a new window? Is there an option somewhere that I missed?


Thanks for the help!
Daph

 

[imatthec]

daph,

In your spreadsheet go to tools->macros->microsoft script editor. Once there select edit->find/replace. In find type in "_parent" and in replace type "_blank". This should take care of your issue. You'll need to do this for each sheet in the workbook. All sheets will be listed in a pane on the right side of the screen. Once done, click save all.