Hide prompt to automatically update links on workbook opening

[DannySS]

What is the best way to hide the Window which prompts the
user to choose as to whether to update the links to other
workbooks or not on opening the workbook. I do not want
all users to update these links i only want 1 user to
update the links through the edit menu and nothing else.

Thanks in advance.

DannySS

 

[Bob Flanagan]

Danny, the only way is to have a macro in another workbook or add-in open
the file for the user, and when doing so set update links to false in the
open statement.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel