Macro copying macro code
 

Our company needs to send out an excel spreadsheet to several of ou
companies - but the original worksheet is generated from within
macro. We need to be able to insert some macro code into each of th
spreadsheets that we send out to our customers enabling them to send
response or forward information from buttons linked to the macros tha
we want to enbed in each of the outgoing excel spreadsheets.

Do you know of any way to copy a predefined macro into the new exce
spreadsheets from within our originating macro

--
TNSKHel
-----------------------------------------------------------------------
TNSKHelp's Profile: http://www.excelforum.com/member.php...fo&userid=2441
View this thread: http://www.excelforum.com/showthread.php?threadid=38011

Macro copying macro code
 

Check this link 'Programming To The Visual Basic Editor
(http://www.cpearson.com/excel/vbe.htm

--
Nori
-----------------------------------------------------------------------
Norie's Profile: http://www.excelforum.com/member.php...fo&userid=1936
View this thread: http://www.excelforum.com/showthread.php?threadid=38011