Avoid displayalert message while opening file

[Vijay Kotian]

I am opening a file containing links to other data source, when i open file
it always ask for Update links. It flashes a message on the screen, to avoid
flashing on the screen or to Update links by default I tried to use command
"application.displayalert = False".

Eventhough this command is given it continues to flash the message. Can
anyone help me out to avoid this message repeating everytime opening the file.

 

[Trevor Williams]

Hi Vijay

Change the Links Startup Prompt:

Within the workbook click on Edit | Links | Startup Prompt
and make your choice.

Trevor

 

[Shawn]

Is there a way to put this in the macro code where the person on the other
end trying to open up a workbook that I have generated via macro will not
have to set up their excel for this?

 

[Trevor Williams]

Hi Shawn

You could try adding this into the Workbook module;

Private Sub Workbook_Open()
Me.UpdateLinks = xlUpdateLinksAlways
End Sub

OR

Create an Auto Open procedure in a standard module:
(this will run automatically when the workbook is opened)

Sub Autpen()
ActiveWorkbook.UpdateLinks = xlUpdateLinksAlways
End Sub

HTH
Trevor