I hope i understand your problem.
Perhaps i have some of the answer.

If your macro starts as private sub xxxx()
Write public insted of private.
Move all the macros in a module pad in macro editor.
Rename the module to known name in properties wondow.
Then copy all your macros to the module with your private name.

Then you are able to export the module file to other workbooks.

Theis is just one way, there ar others to.
Best regards
Øyvind
--
Øyvind


"gerbilspy" wrote:


New here, I've searched and researched, but have been unable to find the
answer to my question...so here goes: (I hope this isn't such a dumb
question that no one wants to bother with it!)

I have a series of macros I've recorded in a workbook, and now I want
to create a macro to run them all in sequence, and then create a
template that I can use anytime I get new data. I want to just import
the new data into my newly created document, and run the One Macro that
Rules them All, instead of having to run all 8 of them individually. I
am totally new to recording macros and I just was unable to do
everything in one great big macro.

I have tried to record the macro, and it works fine in the workbook,
but when I create a template from it and then create a new document off
the template, I get the error message: runtime error 1004 - it seems to
be looking for my macro in the template- which of course isn't opened.
The macro DOES work in the newly created document if I open the
template too, but I would like to be able to avoid that if possible.
I've tried putting the macro in a Personal Macro Workbook but that
didn't work either.

One more thing, is there a way to have the macro run but not be able to
see everything that it's doing? Makes me dizzy! :)

Thanks for you help!


--
gerbilspy
------------------------------------------------------------------------
gerbilspy's Profile: http://www.excelforum.com/member.php...o&userid=28047
View this thread: http://www.excelforum.com/showthread...hreadid=475520