Run Macro in one Workbook From another

[fire_water]

Here's the situation:

I have a vba Project that asks the user if he/she wants to add an option. If he or she choses "no", the the sub exits. If they choose "yes" then the code opens a workbook template, saves it with a specific name, and takes the user there.

What I need is for a specific macro to be run, (exists in the template book) only when opening the workbook through this method.

Any ideas?

If you have trouble understanding what i mean, just let me know and i'll try and be more clear.

Thanks

[royUK]

It would be much simpler to have the macro in the main workbook.

If this is not possible declare the new workbook as an Object Variable hen use that variable to run the macro.

Post the code that you are currently using then I can show you what i mean.

[fire_water]

Thanks, I went ahead and did some modifying and put it in the main workbook and it works fine now.

[royUK]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save