How to open workbook in the same Excel app

[Jeff Armstrong]

Hello,

I have a list of hyperlinks to other Excel files in column
A and I have a macro that opens each file through a loop.
The thing I don't like is when the file is opened, it
opens another Excel app at the bottom of the taskbar. I
have the Screenupdating = False but this doesn't prevent
this. Is there a way to open the file in the current
window? Below is the code I am currently using.

Selection.Hyperlinks(1).Follow NewWindow:=False,
AddHistory:=True

Any help would be greatly appreciated.

Thanks,
Jeff

 

[Ron de Bruin]

Tools>Options>View

Windows in Taskbar