Try taking a look here ...
http://www.cpearson.com/excel/vbe.htm
HTH.
"whatever" wrote:
I just noticed there is a problem with one macro I wrote that has been
put into more than 70 similar but different files.
Instead of going into each file to edit the macro, is there a way to
create a macro and go into each file to fix that problemlic macro?
I can loop through a list to repeat same actions for these 70 or so
files, but couldn't figure out a way to use macro to change another
macro.
Help please. Thanks.