To run without seeing it run:
Appication.DisplayAlerts = false
You don't have to set it back to true if the macro completes before giving
control back to user, it is automatic.
HTH.
Bill Benson
http://www.vbacreations.com
"gerbilspy" wrote
in message ...
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