Marianna has attended:
Excel VBA Intro Intermediate course
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
RE: Assigning Macro to new workbook
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
