Can macro build new macro in another workbook??? Pleeease HELP
 

:( I have a macro witch build a new workbook. It's OK. But *I nee
create new macro in this new workbook automaticaly* (So macro buil
another macro in another workbook). This new macro have to be i
Worksheet - Worksheet_Change - not in modules.

Could anybody help me create or copy macro to a new workbook, please?

Many Thanx

Marty

--
Marty
-----------------------------------------------------------------------
MartyZ's Profile: http://www.excelforum.com/member.php...fo&userid=1635
View this thread: http://www.excelforum.com/showthread.php?threadid=27740

Can macro build new macro in another workbook??? Pleeease HELP
 

See Chip Pearson's page on programming the vbe

http://www.cpearson.com/excel/vbe.htm

It shows how to create code with code (including event procedures).

--
Regards,
Tom Ogilvy

"MartyZ" wrote in message
...

:( I have a macro witch build a new workbook. It's OK. But *I need
create new macro in this new workbook automaticaly* (So macro build
another macro in another workbook). This new macro have to be in
Worksheet - Worksheet_Change - not in modules.

Could anybody help me create or copy macro to a new workbook, please?

Many Thanx

MartyZ


--
MartyZ
------------------------------------------------------------------------
MartyZ's Profile:
http://www.excelforum.com/member.php...o&userid=16355
View this thread: http://www.excelforum.com/showthread...hreadid=277407