View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default Adding code to workbook_open at runtime

How would one go about adding code to the thisworkbook object at runtime so
that a workbook_open macro is added. I want to be a able to create a
blank workbook, add data to it and then add a workbook_open macro that will
of course run when open. if it is not possible to add code to thisworkbook
object, is there another way to accomplish this. Any ideas? any links to
pages with working with vbaprojects?
thanks,
ben