Use Application.OnTime to start the macro in the second workbook. This will
break the link between the code in the two workbooks.

Application.Ontime Now, "Workbook2.xls!Macroanme"

--
Regards,
Tom Ogilvy

"reesmacleod" wrote in message
...

Thanks for the thoughts, however, the program requires that they have
only one workbook open at a time or it will cause other problems not to
mention way too many books open,

Thanks again for the quick reply though


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to
creating financial statements