Gordon, the only other way that I know is pretty drawtic. That would be to
create a new worksheet by copying the entire sheet and PasteSpecial with
xlValues to eliminate formulas and links. Then send the user that copy.
Like I said, that's drastic.

"Gordon" wrote:

Hi...

That gets rid of the first box. How do I then get rid of the...

This workbook contains one or more links that cannot be updated - box.

Cheers

Gordon...

"JLGWhiz" wrote:

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...