Guys Problem Stated: Working in

[GuruJosh]

Guys

Problem Stated:
Working in an Excel 97 environment using VBA, I would like to trap the event of an updated internal link.

I have an internal link between a Source and a Target sheet.

I have created an Application object WithEvents in an Events ClassModule to control and capture all events in a session of Excel.

I am not able as yet to successfully trap the event of the Target sheet linked cell to the Source sheet being updated when there is a change in the Source sheet linked cell.

Your assistance will be greatly appreciated.


Thanks in advance.

 

[Store300]

You can swith off the automatic updating of links and then use your VBA to state when you want them to update:

Workbook.UpdateLinks

Store300

Store300@ftnetwork.com