MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help extracting Macros from Excel

Posted by Todd on July 31, 2001 9:47 AM

Need to see if it is possible and if so how to extract a macro from an Excel file. My problem is I have 1 macro in a file that is causing the system to lock up whenever I try to open the Visual Basic editor, try to run the macro, or try to save with any changes. This file also has the majority of the other macros and forms I have developed and I do not want to lose these.

So what I am wondering is if anyone knows how I can extract these macros without running Visual Basic editor. Thanks.

Posted by Kelsee on August 01, 2001 9:02 AM

Try opening your workbook with the macros disabled. This will enable you to open the visual basic editor and delete the macro or fix it.