View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Warren Jim Warren is offline
external usenet poster
 
Posts: 7
Default programmatically create a macro

I am dispersing large amounts of monthly data by creating and emailing
workbooks in a macro. In the largest of these workbooks I would like to
create a macro that would be triggered by clicking the mouse in various cells
of one sheet. The macro itself is no problem, it's programmatically getting
the macro and the event code into the new workbook that is the problem. So
far I have not found a way to do this. Does anyone have any suggestions?