Update Links including highlights and comments

[malou]

Hi,

Is it possible to update the links including the highlights and comments in the cell? As a background, I have 2 identical workbooks.

Workbook 1 - has my actual data. It also has a vba macro event where if there are changes made, the cell will be highlighted and a comment will be added to show the previous value and who did the changes.

Workbook 2 - is linked to workbook1. It has an "update" button that once click will update the workbook. This works fine without the added event macro on workbook 1.

this is my code for "Update" button

Sub Button4_Click()ActiveSheet.Unprotect Password:="xxxxxx"
ThisWorkbook.UpdateLink Name:=ThisWorkbook.LinkSources
ActiveSheet.Protect Password:="xxxxxx", AllowFormattingCells:=True
End Sub

Can you help me fix my code to include highlights and comments made in workbook1?

thanks in advance.

 

[malou]

Help please....

 

[malou]

anyone please...

 

[malou]