You can try this in the ThisWorkbook code area:

Private Sub Workbook_Open()
Application.AskToUpdateLinks = False
End Sub

However, since this tells it to automatically update, he might get a message
saying it can't find the links. My limited knowledge leads me to believe you
might have to comment out the links when you send it.


"Gordon" wrote:

Hi...

I have a complex file that needs sending to another laptop/user. The file
has many links to other files. The person I send this file too doesn't like
the "would you like to update links?" box, and the "some links don't work box
would you like to continue" box. Basically I want no hint there are any links
at all in the file. Any help with code would be gratefully received.

Gordon...