I'm trying to do the exact same thing...if anyone has any suggestions,
I'd love to know the answer.
---------
Message sent via www.excelforums.com

Ben and tedsec

"Is there a way to pass of control of the
macros to the next workbook? eg.. book2 book3 book4.... etc..."

For this very reason, I never attach toolbars to workbooks - especially
templates. I always create and delete the workbooks in code. I have become
partial to creating the commandbars in the Workbook_Activate event and
deleting them in the Workbook_Deactivate event. Other people use Open and
BeforeClose. I like the activate events because I can have two workbooks
based on the same template open and not have to worry about where the
toolbar macros are pointing. I know they're always pointing to the active
workbook.

See here http://www.dicks-blog.com/excel/2004..._commandb.html

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com


"tedsec - ExcelForums.com" wrote
in message ...
I'm trying to do the exact same thing...if anyone has any suggestions,
I'd love to know the answer.
---------
Message sent via www.excelforums.com

also I can never
seem to get the workbook activate, deactivae events to work.. any
thoughts??


I don't know of any specific issue with those events. They work okay for
me. Make sure Application.EnableEvents is set to True.

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com