Control update of links
 

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

Control update of links
 

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

Control update of links
 

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

Control update of links
 

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