Macro to change text in macro on control button in workbook?

[Rookeby7]

I have inherited a process which has a template workbook with Macro buttons so users can move to specific sheets.

The template has been used to create approx 700 files.

I have been making some amendments to the template, which has included changing one of the worksheet names - this means one of the macro buttons no longer works as it is looking for a sheet which no longer exists.

Is it possible to create a macro to open an embedded macro and find/repalce the sheet name? (and loop through 700 files?)

Or is it possible to assign a new macro to the existing button? (and loop through 700 files?)

Hope someone can help, thanks in advance

 

[Rookeby7]

If the tab names have not been changed in the 700 files, why do you need to change the macros in those files?

The intention is to make the change to all files, which will then be updated annually

 

[footoo]

It could be done with a macro that loops each of the 700 files, deletes the old macro and inserts the new macro.
Whoever creates the macro will need to know:
- the location of the 700 files
- the workbook name and module name containing the new macro
- the module name containing the old macro in the 700 files, and whether there are other macros in the same module.

Or perhaps you just want to change the sheet names in the 700 files without changing any macros?
I'm not clear as to what you need.