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