Look at Chip Pearson's page on working with the VBE with code
http://www.cpearson.com/excel/vbe.htm
--
Regards,
Tom Ogilvy
"Darshan" wrote in message
...
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.