Another option would be just to leave the code in its own workbook.

Then have that "macro workbook" open whenever you need to run the macro.

(I've found that it's easier to make a change in one workbook, than to find all
the workbooks and update all those.)

Darshan wrote:
>
> I am creating a new workbook with a macro. I want the macro to be copied to
> the new workbook too automatically so I can run that macro again from the new
> workbook.

--

Dave Peterson