Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have 2 workbooks one called "A" and the other "B". THere is a cell
in a worksheet in workbook "B" that hyperlinks to a cell in workbook "A". When a change is made to the cell in book "A" the hyperlink in book "B" updates to show the change. My problem is that I want to run a macro when the cell in book "B" changes. The problem is I can not find a event that is triggered when this update is made to book "B". I can run code when book "B" is activated by me looking at it and such but I want code tied directly to the updating or refreshing of a specific hyperlinked cell. The before hyper link event on a worksheet only works if you are clicking on a hyper link to go to it or something. I dont want to have to click on anything. If someone can help me with this hyper link problem I would sure appreciate it. Thanks Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
refresh event pivot | Excel Programming | |||
How to refresh data analysis tool results | Excel Worksheet Functions | |||
refresh advanced filter results | Excel Discussion (Misc queries) | |||
PivotTable After Refresh Event??? | Excel Programming | |||
Pivot Table Refresh VBA Event | Excel Programming |