Display Alerts problem..

[JST013]

Hello all,

So I'm having a bit of trouble understanding Application.DisplayAlerts....

Why can it not stop this error from displaying...

I have this in a workbook open event and every time it opens it shows this alert. I also run some code to update my links which is why the alert is even more confusing...The links update just fine as well.

The following is the relevant code...

'I also tried this 
'Application.AskToUpdateLinks = False

Application.ScreenUpdating = False
Application.DisplayAlerts = False

'the code here to update my links that I know works[INDENT=2]linkarray = Workbooks("Assembly.xlsm").LinkSources(xlExcelLinks)[/INDENT]
            x = linkarray(1)
            Workbooks("Workbook1.xlsm").OpenLinks x, True, xlExcelLinks
            Workbooks("Workbook2.xlsm").Close False
Application.ScreenUpdating = True
Application.DisplayAlerts = True

What am I doing wrong? :D Is it possible to not display that alert?

 

[KeepTrying]

Hi,
Maybe it helps:
<code>

Application.AskToUpdateLinks = false

'some code

<code>Application.AskToUpdateLinks = True

</code></code></pre>

 

[Trevor G]

Try using this

Sub Links1A()
Application.AskToUpdateLinks = False

'What do you want to do here

Application.AskToUpdateLinks = True
End Sub

 

[JST013]

Thank you for the reply, but that did not work either...Maybe I just have to live with it

 

[JST013]

I got it to work...I'm not sure why this worked but....

Private Sub workbook_open()
    linka
    Application.ScreenUpdating = False
    coveractive
    Application.ScreenUpdating = True
End Sub

Private Sub linka()
    Application.DisplayAlerts = False
End Sub


Sub coveractive()
    Dim cover As Worksheet
    Set cover = ThisWorkbook.Sheets("Cover")
    cover.Activate
    Application.DisplayAlerts = True
End Sub