MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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()
End Sub

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)


Posted by Jack on November 23, 2001 2:22 PM

Your idea is cool BUT it has that thing i hate VIRUS written all over it, this of cause it is not but someone knowing who to do such tricks i know would never post the answer, writting from code to code, hiding, invisable and bridging security sectors is something we all want to know and would love to do, but hey... some fool will abuse it they always do, so dont build you hopes up on getting and answers even though your question i quite like, i can see trouble ahead.

Take care mate, i know you see my point.

Posted by Ivan F Moala on November 23, 2001 2:42 PM

if interested I can send you an example....not
too hard to build........I did one a while ago
see previous posts going back ??
Other wise email me and I'll send you an example