I have an Excel workbook with 14 userforms (each one is for entering a slightly different type of data). The workbook has been behaving strangely--the Excel application quits whenever I close a form. I'd like to copy all of the forms into another workbook, so I can see if it's a corrupted workbook or if the problem is in my code. But in the VBE I can only copy one form at a time. Is there a better way to copy several forms at once?
The best thing I've found for fixing Excel files with corrupted macro binaries is the free VBA Code Cleaner. Installing it will add a
If that doesn't work or you really want to move all the modules out of the existing Excel file into a new file, the other thing I use is the Source Tools Addin. If you want this to always be available, save it to