View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default How to open workbook in the same Excel app

ToolsOptionsView

Windows in Taskbar

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Jeff Armstrong" wrote in message ...
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