Copying a macro to another excel workbook

[lj]

I am copying several sheets from an excel workbook to a new, blank
workbook. Is there anyway to also copy a macro to the new workbook as
well? It seems like one way to do this would be to copy the whole
workbook and then delete the things I don't need. But what i'm hoping
to find is a specific way to just copy the specific macro I need
without having to copy the whole workbook. Any suggestions?

 

[Dave Peterson]

Chip Pearson has some code for programming to the VBE at:
http://www.cpearson.com/excel/vbe.htm

Have you thought about creating a template file that contains all the code you
need (might not be possible, but if it is, it might be easier).