Export codes to a closed workbook's code page.

[ebse]

Is it possible to write some codes to the "workbook" or "worksheet" of a closed workbook.For example :


Private Sub Workbook_Open()
MsgBox "Hello"
End Sub

It is possible to export a module to a closed workbook but I wonder if it is possible to export the code above.