Edit Macro by Using macro in hundred of sheets

[Cloud67]

Hello,

I have one workbook with few macros. This will be distributed among users who will then create copies of it in a folder. I am expecting hundred of copies. If later on for some reason I would edit a macro in all of these sheets, is there a way to do it at once with some other macro? Those files will not be on my computer that is why I cannot use personal macro. They will be on sharepoint. I will download them on my computer and then edit the macro for all of them.

Greatly appreciate the help!

Thanks,
Ofeera

 

[rlv01]

Speaking as someone who maintains some macro-enabled workbooks used by 100+ users, that approach sounds completely unworkable to me. Instead I recommend adopting a formal versioning approach. If you need to modify a macro (for bug fixes or new features) you issue a new version of the workbook that you post to a repository and then notify your users by some means (email) that a new version is available and where to get it. If we are talking about a business internal sharepoint, you can add a "check for new version" button that the user can press to check for any new version. If there is user data in the old workbook that your users may need to transfer to the new version when they upgrade to it, you should write some sort of import macro(s) to make it as painless for them as possible.

 

[My Aswer Is This]

If I want to have the same Macro, I want to put into several Buttons on my workbook I just create the one Macro named "Alpha" for example. Now this is a Module script not a private script.

Then in all the buttons where I want to run this button from, I just enter:

Call Alpha

Call Alpha then runs the script named Alpha

This way I only need to modify the one script named Alpha
Not all the scripts in all my buttons.