here is a web site that has a lot of code examples to modify other code

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

It's a good starting point

david

"Scott Bedows" wrote:

I have a rather extensive excel file (131 pages and 4MB) that it used by 80
different users each in a remote location. I'm trying to make some updates
to the file without copying over each users copy of the file. I thought
about writing a macro/code to make changes to the necessary cells/worksheets,
which I can do. Where I'm running into problems is that some of the changes
need to be made to a few of the macros. Is it possible to setup one excel
file macro to change the macros in another file? If so, how?

Thanks so much,
Scott