VBA Code to Import VBA Modules

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top