I did a paste all - link from several other excel
spreadsheets. I notice when I update them the master
spreadsheet is updated with new values. I tried to
trigger the macro and the funny thing was it would
trigger when i updated one of the subsidiary spreadsheets
but not on the others, although the updates did happen.

Wayne
-----Original Message-----
Hi Wayne,

Are you referring to DDE, web queries, or something else?

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address
unmonitored]


Wayne wrote:
Does this work when a cell is paste linked to another
excel file and that file changes, does that trigger the
on change event?

Wayne

-----Original Message-----
Hi shovit,

Yes - you can use the Worksheet_Change event
subroutine to do this.
To get there, just right-click the worksheet's tab in
Excel and
select View Code. Then, change the left dropdown
above the code
module to Worksheet, then change the right dropdown
to Change. Call
your macro from that subroutine, and each time any
cell on the
Worksheet changes, your macro will be executed.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address
unmonitored]


shovit sahai wrote:
Hi,

I have a spreadsheet which is linked to live feeds
from say
Reuters. I need to write a macro which auto-runs
itself every time
the spreadsheet refreshes, or there is change in any
of its cells.
Something to the effect "On every refresh, Do bla
bla bla". Is there
a way to implement this in VB?

TIA

*** Sent via Developersdex
http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for
it!

.
.