How do I write code to "Workbook_Open" from within a VBA?

M

MikeZz

I have a macro that sets up a new workbook and adds macros to it.
To do that, I export a module and then import it into the new file.

My question is how I can use VBA in the master workbook to VBA code to the
new Workbook's "Workbook_Open" VBA?

I'm only talking about 1 line to call up a dialog box so hopefully it's not
that difficult.

Thanks
MikeZz
 
M

MikeZz

Wow, Thanks for the quick reply.
Don't have time to read it now but it looks like a site I had linked before
but I recently lost my favorites.
 

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

Similar Threads

VBA Coding Help for Beginner 0
VBA code to import worksheets from other workbooks 9
How to open a specific worksheet via code from workbook_open 5
How to use VBA to set WB to Shared Status 3
VBA code won't run, even with Macro Security set to Enable All Macors 9
Fire Code after Preceding Events Run 0
Workbook_open not running and Phantom Projects 6
How to open a specific worksheet via code from workbook_open 1

Top