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!
.