Hello! Could anyone please help me. I have this worksheet called
"rplan.xls" that automatically updates with new data from other worksheets
and this worksheet have two macros that formats range cells called "Month"
and "Year" base on the new data. My problem is how can make these two macros
run after the worksheets has been updated? Thank you very much in advance
for the help.

Perhaps call them in the Calculate event.

Chip Pearson's page on events:
http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"arm" wrote in message
...
Hello! Could anyone please help me. I have this worksheet called
"rplan.xls" that automatically updates with new data from other worksheets
and this worksheet have two macros that formats range cells called "Month"
and "Year" base on the new data. My problem is how can make these two
macros
run after the worksheets has been updated? Thank you very much in advance
for the help.