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

See www.cpearson.com/excel/vbe.htm for details and example code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jeff" wrote in message
...
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