I have created an excel macro in a workbook. What I need to do is edit the excel macro from another excel worksheet. IE do a find and replace on the macro code in the other sheet. I cannot replace the current sheet as it contains important data. This excel sheet is widely deployed and so Ideally I want to write a macro which opens the sheet, edits the code and then saves it. Any ideas?