Application.Run ("yourfilename.xls!yourmacroname")

--
HTH...

Jim Thomlinson


"Rpettis31" wrote:

Is there a way to activate macros from different workbooks. I have several
workbooks I update in the am and was wondering if there was a way to have an
update workbook so to speak and update all the other workbooks from the main
workbook.

Thanks