Message box pops when another workbook modified or saved

[thameem127]

Dear Experts,


I need coding for message box pops in a workbook when another workbook modified or saved.

[Gopal Veeranala]

Dear Experts,


I need coding for message box pops in a workbook when another workbook modified or saved.

another workbook ??? means?
can you explain clearly..

[thameem127]

That means another file.

I have two files.One is Main file is in Shared folder- Network and another file (personal)is in my desktop . The message box should pops up in my personal file when the main file in public folder is modified.

[thameem127]

Still I am waiting for the answer.

[Gopal Veeranala]

hi, thameem

Below Code in "ThisWorkbook" can popup message

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
MsgBox "Changed"
End Sub

but have to workout how to link this vba to another workbook

[thameem127]

Any way thanks for your answer but this is not what I required.