Worksheet Update

[jumbo1979]

I have:

Private Sub Worksheet_Change(ByVal Target As Range) code in this worksheet so that the code runs everytime the data refreshes, however the data is all formulas linked to another worksht. So even though the data values are changing - the actual data is NOT changing so the Change code never runs. Is there a way around this?

 

[CautionMP]

jumbo1979,
This is a stab in the dark, [tt]Worksheet_Calculate()[/tt]?

CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[RonRepp]

Instead of the worksheet change event (this only fires on your workbook if the user changes a value in the cells), use the Update Links.

Create a toolbar button and create code that looks something like this:

ActiveWorkbook.UpdateLink "C:\MyLinkedWB.xls", xlExcelLinks

I hope this helps

Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.