Macro to copy worksheet to new workbook including macros

[depcdivr]

I know how to copy a worksheet from an open workbook to a new one. However, I also have several Macro's that are attached to the worksheet. I need to copy these macro's(or entire module) into the new workbook. Is this possible?

I need to do it with a macro because the original spreadsheet will be used by many people who will not know how to import a module.

 

[al_b_cnu]

Hi,

Could you use the 'SaveCopyAs' workbook method?

 

[depcdivr]

What I am doing is actually creating a new workbook from my original macro. But I want that workbook to have macro's in it that I can access from the newly created workbook. Therefore I want to copy a module with macros in it over from the old workbook to the new workbook.

I can not use the save as because I need the original macro to generate responses and keep a log of information that should not go with the newly created workbook.