Rick,

See www.cpearson.com/excel/vbe.htm for details.


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



"rick" wrote in message
...
I'm quite new to VBA and if anyone can help it would be
great. is there a way to create a new module and insert
code into it through the workbook_open code.

something like:

Private Sub Workbook_Open()

create.module1
With module1.add
"Sheets(2).Select"
End With

End Sub

or alternatively a way to import a module from file and
then run it through workbook_open