I had writen a macro and created a button to run it.
However, I want to auto run that macro after I
update th data in a sheet.
How can I achieve this target

--
hurrianc
-----------------------------------------------------------------------
hurriance's Profile: http://www.excelforum.com/member.php...fo&userid=3088
View this thread: http://www.excelforum.com/showthread.php?threadid=55128

Look at Chip Pearson's page on events

http://www.cpearson.com/excel/events.htm

this would be a start - although "update th data in a sheet" is not well
defined as to when the macro should run.

If it is after each cell is edited, then look at the change event. (or event
if it is a specific cell).

--
Regards,
Tom Ogilvy


"hurriance" wrote
in message ...

I had writen a macro and created a button to run it.
However, I want to auto run that macro after I
update th data in a sheet.
How can I achieve this target?


--
hurriance
------------------------------------------------------------------------
hurriance's Profile:
http://www.excelforum.com/member.php...o&userid=30882
View this thread: http://www.excelforum.com/showthread...hreadid=551282