updating links only for the active sheet

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):

Please Login or Register  to view this content.

many thanks
alper

cross post
http://answers.yahoo.com/question/in...5015505AAt0WeP