Macro to edit macro

Hi,

I need to create a macro that can be used to update the vba in an existing macro. It would need to search the current code for a specific line and then replace it with the new line. Also, the vba editor in the workbook is password protected, so the new macro would need to unlock the editor and lock it again (with the original password) after updating the code.

Is anybody able to help please?

Thanks

Hi CK76, thanks for getting back to me. I created a workbook with numerous macros in as a tool for my job. This workbook has then been copied over 150 times with individual records saved in each. However, I realised one of the macros I built in the original template, has a line missing so I'm looking to create a new macro which I can then get to cycle through all of the saved workbooks, open them individually, update the module and then close the workbook moving onto the next one.

No problem. Will look into it and let you know how I got in. Thanks for your help.

Thanks for your help with this. Have looked into it a bit further and seems super complicated to be able to unlock the editor, let alone replace current modules. Will have a think of alternative options.