Solved: using macro to edit macro

[benong]

hi,
is it possible to update an existing macro by running another macro?
eg. run macro A to edit the program/content/values in macro B.

[Bob Phillips]

It is possible, but it is not a good idea. It is far better to code or each possibility, and then have a switch that controls which possibility is actually run.

[benong]

thanks xld,
i need to change a value in many workbook macro frequently, so i was thinking about automating it.
Can you show me any online example/tutorial/script as i failed to search for one.

[Bob Phillips]

It is not clear what editing you want to do, but Chip has a lot of info at http://www.cpearson.com/Excel/VBE.aspx

[benong]

thanks xld