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 th
'asktoupdatelinks' because it depends on the call Kontres_Update.

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

Thanks in advance
Stathi

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