Updating Links On Protected Multiple Sheets by vba

[erdow]

Hi to all experts, i am trying to update my workbook with multiple sheets. All sheets are same and linked to another workbooks different sheets.
What i need is a code which unprotect all sheets and ask for update link and after user sellect the updated workbook it must update all data on all unprotected sheets and then protect all sheets with same password again. (pages sholuld be locked again before the user can make any changes to the pages)
Thanks in advance..
Erdem..

 

[erdow]

Any help

 

[erdow]

Hi to all experts, i am trying to update my workbook with multiple sheets. All sheets are same and linked to another workbooks different sheets.
What i need is a code which unprotect all sheets and ask for update link and after user sellect the updated workbook it must update all data on all unprotected sheets and then protect all sheets with same password again. (pages sholuld be locked again before the user can make any changes to the pages)
Thanks in advance..
Erdem..

Actually not update links, i need to change the source file for links