View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How do I copy macro into new workbook that was created automatica.

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.