updating links only for the active sheet

**alpertheidiot** · 06-15-2009, 03:57 AM

hi guys,

I have a workbook which has links to another excel workbook (source). This workbook has many sheets -all exact copy- with different names.

I changed startup prompt (edit-links) to "dont display the alert and dont update automatic links". Then I recorded a macro for updating links (from source) and assigned this macro to a button. What I want to do is when I click this update button I want links to be updated only on the active sheet. My problem is, when I press this button, it updates all links including other sheets.

So can you please advise how can I do this?

PS. Once I manage updating the active sheet only, I will copy this button (with the macro) to other sheets too. Then I will update which particular sheet needs updating.

My current macro is (I tried changing ActiveWorkbook to ActiveSheet but it didnt work):

Sub update()
'
' update Macro
'

'
    ActiveWorkbook.UpdateLink Name:= _
        "C:\Documents and Settings\Alper\Desktop\Excel\source.xls", Type _
        :=xlExcelLinks
End Sub

many thanks
alper