View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hans Bergman Hans Bergman is offline
external usenet poster
 
Posts: 1
Default Add event code through a macro


My VBA code creates new sheets. I want my VBA code to add
event code for the newly created sheet. Any idea how?

I am really surprised that I could not find the answer to
this question: I did find out how my VBA code could add
controls to sheet, so I expect that it should also be
possible to have you macro add the event code for these
controls.

Thanks for any suggestions

Hans Bergman
Ottawa, Canada