You can automate the process. See www.cpearson.com/Excel/VBE.aspx for
lots of information about how to modify code and components with code.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com



On Thu, 15 Apr 2010 14:50:01 -0700, CLR
wrote:

Hi All.....
I've got 31 Excel .xlsm files to modify the "Change Event" macro in. Is it
possible to open and perform this with code, or must I do each one by hand?

TIA
Vaya con Dios,
Chuck, CABGx3