Write a macro to create a macro
Posted by JAF on November 23, 2001 6:35 AM
I have created a splash screen that I intend to add to all Excel based reports that we provide to users.
What I'd like to be able to do is write some code (stored in Personal Workbook Macro) that when run will import the Splash Screen (C:\My Documents\frmSplash.frm) and also create the following code in the ThisWorkbook module:
Private Sub Workbook_Open()
I'm not sure if this is possible, but if it is then I'm sure someone here will know how to do it!!
Over to you guys (and girls)