title: auto add vba on excel sheet
body: <p>Any way to use vba to add vba code on a worksheet?</p>
  
  <p>I need to create a worksheet with a button on it that allows people to click on the button to select the report they have and then add a double click function on their report page. And I need to share this file on the server for everyone's use.</p>
  
  <p>After they run this file, they are able to double click on their report page's Range("A1:A10") and jump to sheet2 and auto-filtered by the values of the cells in Range("A1:A10"). </p>
  
  <p>I can do the code, just don't know how to add it on their workbook's sheet.</p>
  
  <p>I have been searching for days to find the answer for writing vba by vba, but just no luck. </p>