Save sheet as new file with userform included

[jfoerch]

Hey all,
I have a workbook where I take several of the sheets out and save them as a separate, macro enabled workbook. But, the new workbook still relies on the old workbook for the userform and modules. How do I copy the desired userforms and code to the new workbook along with the worksheets? Is that even possible?

Thanks!
Joel

[davesexcel]

Maybe you could just delete the sheets you don't want and resave the workbook, for eaxample.

Please Login or Register  to view this content.