Re: $$Excel-Macros$$ Copy all userforms to another workbook

Thanks Paul! That is exactly what I needed. -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://ww

Re: $$Excel-Macros$$ Copy all userforms to another workbook

Try this: Sub ExportForms()     Dim vbaModule     Dim VBComp, tmp, Fldr         Set vbaModule = ThisWorkbook.VBProject.VBComponents     Fldr = "C:\temp\forms\"         Application.StatusBar = "Exporting all Forms..."     Application.EnableEvents = False         For Each VBComp In vbaModule