How do turn off Display msg to Update Links when opening fil

[ajmckenna]

Opening many files in a macro, each time macro is prompted to open file is asks wheter you want to update links or not

then new msg box comes asks whether you want to be able to paste info on Clipboard ot another program later.

anyway of getting rid of these through VBA as other people will using this file. and if so does that mean it selects "yes" or "no"

Thanks

AJ

 

[Andrew Poulsom]

Tools, Options, Edit tab, uncheck Ask to update automatic links.

 

[Chas17]

There is also a nice addin to remove links; download from MS.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q188449

 

[ajmckenna]

Thanks I got it codes are
Application.AskToUpdateLinksFalse
Application.CutCopyMode = False
Thanks