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

Hi Marianna,

When you save a macro you have two options; to save it in the workbook in which it was created, or to save it in a workbook called Personal.xls.
If you save it on Personal.xls it is automatically available to any other workbook opened or created on that PC
I suggest you try this, and if it doesn't work or you have further problems get back to us

Regards

Stephen