View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DANMOO DANMOO is offline
external usenet poster
 
Posts: 1
Default Can I use a macro to create a macro in a new workbook?

I have a macro that splits data in a single worksheet into multiple workbooks based on a change of data in a particular row.

Is there a way within this macro to make it create a script in the new workbook that runs when certain cells are altered?

EggHeadCafe - Software Developer Portal of Choice
..NET Compact Framework Missing DataTable .Copy()
http://www.eggheadcafe.com/tutorials...mework-mi.aspx