The updatelinks dialog is shown before any macros are run. To the best of
my knowledge, you can not determine what the user has answer except perhaps
by checking what the values of linked cells might be and I would be hard
pressed to come up with a reliable way to do that.

--
Regards,
Tom Ogilvy

"stakar " wrote in message
...
Hi!
I have a problem
I have the following code
-----------------------------------------------------
Private Sub Workbook_Open()

'Dim active_wb As String
'active_wb = ActiveWorkbook.FullName

Application.ScreenUpdating = False

'If Workbooks.Application(Filename:=active_wb, UpdateLinks:=3) Then
'ThisWorkbook.Close savechanges:=False
Call Kontres_Update
'End If

Worksheets("SH").Activate
Application.Goto reference:="R4C9"
Application.ScreenUpdating = True

End Sub
--------------------------------------------------------
When i open the workbook i want to have the value of the
'asktoupdatelinks' because it depends on the call Kontres_Update.

In other words if i click on 'No' on the 'asktoupdatelinks' form i dont
want to call the macro 'Kontres_Update', but when i click on 'Yes' to
call it.
I tried, as you can see, something but it asks me if i want to save
changes because the workbook is already open

Thanks in advance
Stathis


---
Message posted from http://www.ExcelForum.com/