excel-training-courses - Assigning Macro to new workbook

Hello:

We have a macro that takes a worksheet out of a workbook and saves it as a new file. Within that worksheet that is being imported into a new file, we have another formatting macro attached to it in the form of a button.

The problem is that when the worksheet is saved as a new file, it does not have that formatting macro attached to it anymore.

Is there any way of exporting this formatting macro into a new file?

Many thanks,
Marianna