Look at Chip Pearson's page on working with the VBE with code
http://www.cpearson.com/excel/vbe.htm

--
Regards,
Tom Ogilvy

"Darshan" <Darshan@discussions.microsoft.com> wrote in message
news:AF1B8F44-FEB5-41F4-BF8C-6E64E4DE4BC0@microsoft.com...
> 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.