View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default VBA Code to Import VBA Modules

Hello,

I have an application that creates multiple Workbooks. In each Workbook I
would like to add VBA Code to Microsoft Excel Objects / Sheet 1

Private Sub Worksheet_Change(ByVal Target As Range)
....
End Sub

Is their a way (& if so, how) to add this Code to Each Workbook as it is
being created.

Any help would be greatly appreciated.

Thank you,
Jeff